Ranking by score

Manin

Hello,

I have a sheet that contains people and scores (1-100) based on their performance. I want to create a table to show the top 10 and the bottom 10 people based on their score. Any ideas on how to do that?

Regards,

Manin

I found out how. Created a pivot that pull all people and their score, then did a rankeq with order 1 for top, and then another for ranked with order 2 for bot, and pull report for each using the rank as filter.

Andrée Starå

Hi @Manin,

I hope you're well and safe!

Excellent! I am glad that you got it working!

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!