Duplicate Names When Picking Out Highest Scorer

[webstmonkey]

Hi all!

I found these formulas on an old thread and am using them to pull the names and scores of the 2 highest scoring people from the list of names and scores and putting them in another area of the sheet:

Please Login or Register  to view this content.

I have names is A and scores in B. The results of who scored highest will have names in C2:C3 and their scores in D2:D3.

The problem I run into is if two people have the same score, the first name populates twice.

Any suggestions?

[Richard Buttrey]

Hi,

I don't observe that. Using your formulae the same scores produce the different names. Can you upload your workbook?

[webstmonkey]

Book2.xls

Sorry this took so long. This is a very simplified version of what I'm working with. I did alter the codes because I am working across sheets.

If you notice persons c and q have the same score on sheet 2 and person c shows up twice

Thank you for your help.

[benishiryo]

hi webstmonkey, welcome to the forum. editing your formula, it should be something like:
=INDEX(Sheet2!$A$1:$A$100,MATCH(1,INDEX((Sheet2!$B$1:$B$100=$C17)*ISNA(MATCH(Sheet2!$A$1:$A$100,$B$16:$B16,0)),0),0))

[webstmonkey]

Thank you for both the welcome and the solution! That worked like a charm!