Hi,

I have a set of data like below:
Key Value
A 4
B 2
C 2
D 1
E 5
F 5


I'm trying to find the keys with the largest 3 values-- however, since there are multiple matches (for e.g. E/F with the same value 5), its tricky to get F to be displayed.

I thought the following would work but it doesnt:

* I created a column showing the 3 LARGEST values in order (Col B): =LARGE(A:A,{1,2,3} with teh following result along with a column (Col C) that shows if they are duplicates: =COUNTIF($A$1:A1,A1)
5 1
5 2
4 1
* Now I need to get the rows associated iwth that result. I thought the following formula wouldve worked. =SMALL(IF(B1:B3=B1,ROW(B1:B3),9999),C1)

However, it does gives me a #VALUE.

Any ideas?