Say I have the following numbers in a column

2
3
3
5
5
6
7


I use large to list the top three. I correctly identifies 2,3,and 3. but now I want to get a list of the values in the B col. So I use VLOOKUP to get that data. Since, there are two 3's, it will only look up one value. In a small list like this it isn't too hard to just look, but with 100's of values, is there a way to make sure I get all the values in the B col associated with the doubles in the A col.

I'm open to adding an additional column with the original values to fudge the doulbes, ie: IF(LARGE(a:a,1)=LARGE(a:a,2),a1+.1,a1), but that would do that to the others as well.

any thoughts?

-jed