Top 5 values using LARGE and INDEX avoiding duplicates

Hi

I am trying to get the top 5 values in a list and return some text from an adjacent column. I have names in cells A1:A20 and some numeric value in cells B1:B20. I am looking to get the top 5 names from col A based the values in on col B.

I have tried using LARGE, INDEX and LOOKUPs which almost work but I can not account for two cells having the same value; the end result is that one of the names gets duplicated. I found a post which comes close but I can't get it working; it uses an IF and an OFFSET to check if two values match.
http://www.pcreview.co.uk/forums/thread-3154173.php

I could only get the equation in the above function to return the top 5 values plus 1 (i.e. items 2,3,4,5 & 6).
Could someone please explain or simply the above post, or provide an alternative solution?

Regards, Carl Gilbert

Here's an alternative using a "helper" column. Using VBA Noob's setup, insert a new column A to the left of your names and use this formula in A1 copied down to give a unique rank

=RANK(C1,C$1:C$16)+COUNTIF(C$1:C1,C1)-1

then in G1 copied down to list the names in order

=VLOOKUP(ROWS(G$1:G1),A$1:B$16,2,0)

Thanks!