# Need to do ranking top 5 scorer

1. ## Need to do ranking top 5 scorer

I get a table with players names and amount of goals, need to rank players top scorer and extract their names,rank and goals in other cells.

Attach the example file.

Thanks!

2. ## Re: 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.

3. ## Re: Need to do ranking top 5 scorer

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?

4. ## Re: Need to do ranking top 5 scorer

Excelent!! you're a genius solve my issue

Thank you very much!!

This forum rocks!

5. ## Re: Need to do ranking top 5 scorer

Originally Posted by Spencer101
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.
Spencer101

Thank you very much, I use your suggested to me and solved my problem!

6. ## Re: Need to do ranking top 5 scorer

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

There are currently 1 users browsing this thread. (0 members and 1 guests)