Hello everyone,
So, I have a questionnaire with question each scoring from 1 to 10.
I have ten people who are responding to these questions. I made an average out of these responses and sorted it based on two categories. Now, I am trying to make Excel show me the top 10 that were scored the highest for both categories. Would you mind helping me with the formula, please?

I was already helped with that once but for some reason cannot replicate it. PLEASE HEEEELP!

The columns of my excel spreadsheet look as follows:
A: Question
B: Score by Category A
C: Score by Category B

I would like to have 10 highest scored questions for category A and category B

I have the Excel spreadsheet, so if anyone feels capable of helping, please contact me at lidalik@gmail.com I will send it to you right away.
Thanks!

Lidia