this formula also works to perfection, great guys
On Wed, Feb 8, 2012 at 4:04 PM, Kris wrote:
> Hi,
>
> PFA
>
> Kris
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula P
Hi
OK. Try this.
In A1 on Summary,
=INDEX(A3:A14,A2)
In AD3 on 'FINANCIAL ANALYSIS'
0
In AD4 and copied down,
=IF(B4<>"",IF(B4=Summary!$A$1,LOOKUP(9.99E+307,$AD$3:AD3)+1,""),"")
In AE3
=MAX(AD4:AD38)
In E5 on 'Summary' and copied down & across,
=IF(ROWS(E$5:E5)<='FINANCIAL ANALYSIS'!$AE
Great Kris,
Seems to be getting there but what about the other members under the
industry eg Agro has Benso and GWEB, ie 2 members , banking has eight
members, you formula is great in populating the first line but what about
the other members. thanks in advance, you guys are realy good
On Wed, Fe