Formula to figure out Top 10 names

[cartica]

Hi-

I am trying to write a formula that will give me the top 10 names as a percentage of my overall portfolio. The % are in column C, and they can change daily.

Thankstest.xlsx

[Pete_UK]

I assume you don't want "Cash" to be included in the list, so put this formula in D3:

=RANK(C3,C$3:C$28)+COUNTIF(C$3:C3,C3)-1

and copy down to D28. Then put this formula in, say, F2:

=INDEX(A:A,MATCH(ROWS($1:1),D:D,0))

and copy down to F11.

Hope this helps.

Pete

[RobertMika]

Would this work fir you??
=INDEX($A$3:$A$28,MATCH(LARGE($C$3:$C$28,ROW(A1)),$C$3:$C$28,0))

[cartica]

Rob-

What does the row() do? It's not $, so if I copy down, I don't understand the significance of it?

[AZ-XL]

Hi
For names
=INDEX($A$2:$A$28,MATCH(LARGE($B$2:$B$28,ROW()-1),$B$2:$B$28,0)) Ctrl+Shift+Enter
For numbers you can use vlookup

[RobertMika]

You do not need $.
A1 stands for 1.Dragging down you have A2 for 2.....

[popipipo]

Have you tried a pivot table?

[Tony Valko]

Using ROWS is more robust.

[RobertMika]

@Tony
You are right:
=INDEX($A$4:$A$29,MATCH(LARGE($C$4:$C$29,ROWS($A$22:A2)),$C$4:$C$29,0))

(to mention this will fail on duplicates)

@AZ_XL
There is not no need for CSE