Thread: Solving a duplicate output problem

I have 2 columns: 1 with a corresponding value and 1 with text describing an object. I then have 2 columns after to make 4 total. The 3rd column I used multiple Large functions to sort the values from highest to lowest. Then I used a vlookup to match the value from the 3rd column to the corresponding text matched with the number to output the text. My problem is two objects have the same value so when I use vlookup, it just outputs the first text found twice. How would I be able to find that second text object with the same value? I hope this makes sense.

Despite your very good explanation, attaching a sample file would make life easier for you ... and for the Forum contributors ...

Oh, sorry. Here is an example.

Hi,

You seem to be dealing with tie-breaks for your ranking ...

Take a look at Chip's solution ...
http://www.cpearson.com/Excel/rank.aspx


HTH

Thanks, I will attempt that way.