Help with sorting the results by the top 10 answers

[lidalik]

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 [email protected] I will send it to you right away.
Thanks!

Lidia

[ChemistB]

What do you want returned? the number? the associated question?

[contaminated]

I have the Excel spreadsheet, so if anyone feels capable of helping, please contact me at [email protected] I will send it to you right away.

You can attach you xls file right hereş Check FAQ..