Look up question responses and give me top and bottom 5

[gentelmanJ]

Hi new and first question can you please help?

In col A are questions and in Col B are a rating from 0-5. total of 126 questions.

I need a formula to give me the Highest 5 and lowest 5 response from col b but I need them to tie into question.

Col A questions will remain consistent but the answers in Col b change.

I need to be able to see the question and top 5 and bottom 5 responses.


thanks

 

[Tubal]

Ok, so there are 126 questions that can be answered from 0 to 5. Will there be multiple copies of the 126 questions compiled?
My first impression is to "stack" all the questions and answers in column A & B.
So if 10 people answer, then there should be 1260 rows.
for the first 126 rows (each question) enter

C1:  =SUMIF($A$1:$A$16,A1,B1)

Then use Data: Filter: Auto Filter and pick the top/bottom 5 to display.

Tubal

 

[Tubal]

Oops:

$A$1:A$16 should be $A$1:A$126