Need to do ranking top 5 scorer

Hi,

Here's one way of doing it.
I've added a "unique rank" in column E and used that with INDEX/MATCH to look up the names and goals scored data.

Hope that helps.

S.

Hi and welcome to the forum

You have a few duplicate goal values in D (as would be expected), so i added a helper column in E and used this, copied down, to deal with the duplicates - you can hide this if you want...
=COUNTIF($D$2:D2,D2)/100+D2

Then in D44, copied down, use this...
=INDEX($D$2:$D$41,MATCH(LARGE($E$2:$E$41,ROW(A1)),$E$2:$E$41,0),1)

and in B44, copied down, use this...
=INDEX($B$2:$B$41,MATCH(LARGE($E$2:$E$41,ROW(A1)),$E$2:$E$41,0),1)

let me know if this is what you wanted?

Glad to help.

Don't forget to mark your threat as "SOLVED".