Getting placings from list that contains duplicate values

[C Needham]

I have a list of peoples names and scores. Then I sort them into largest to smallest, and want to assign placings.
This isn't a problem until I have two people that have the same score: then my largest to smallest list shows the two scores, but with the first-occurring name showing for both.
Can someone please help me with a way to show both names?

Please see attached example.

[bebo021999]

Try in G2:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Drag all down

Attachment 622485

[C Needham]

Thank you very much for that! Works perfectly.

I don't understand the formula, but it give me the result I need.

I really appreciate the help.

Chris.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.