Highest 10 values and names returned.

[Inversion]

Struggling to make this work. I have a table with with scores for each name for each month, I am trying to put the top 10 scores in descending order along with the names for each score. Also need the formula to only return the values for the current month



Top Scores 1.xls

Cheers
Damian

[grizzly6969]

check out this file to see if it helps

[Inversion]

Exactly what I wanted.
Thank you grizzly6969

[grizzly6969]

glad I could help
I forgot to mention this is an array and must be entered with Ctrl + Shift + Enter >>> not just enter
do not put curly brackets in manualy

{=INDIRECT("A"&SMALL(IF($C$4:$C$44=E48,ROW($C$4:$C$44)),COUNTIF($E$48:E48,E48)))}