Excel - Problems with creating top 10

[rob1979]

I have a (small) problem with creating a top 10 in excel.

Till now, I am able to make the top 10 with the next formula:

names in column A, amounts in column B, then

=INDEX(A:A,MATCH(LARGE(B:B,1),B:B,0),1)

and then
=INDEX(A:A,MATCH(LARGE(B:B,2),B:B,0),1)
=INDEX(A:A,MATCH(LARGE(B:B,3),B:B,0),1)

But if, for example 2 names have the same amounts, for example on th
7th and 8th place, it gives two times the same name !!!

How can I correct this, so that there are 2 (different) 7th places an
the next one is the 9th place???

Thanks,

Ro

 

[Paul]

I have a (small) problem with creating a top 10 in excel.

Till now, I am able to make the top 10 with the next formula:

names in column A, amounts in column B, then

=INDEX(A:A,MATCH(LARGE(B:B,1),B:B,0),1)

and then
=INDEX(A:A,MATCH(LARGE(B:B,2),B:B,0),1)
=INDEX(A:A,MATCH(LARGE(B:B,3),B:B,0),1)

But if, for example 2 names have the same amounts, for example on the
7th and 8th place, it gives two times the same name !!!

How can I correct this, so that there are 2 (different) 7th places and
the next one is the 9th place???

Thanks,

Rob

Take a look here for lots of good ideas - including a section "Unique
ranks":
http://www.cpearson.com/excel/rank.htm

 

[rob1979]

Thanx , it works excellent now!!