Ranked Scoring

Hi Experts,

I am looking for some advise on calculating the 1st, 2nd and 3rd highest score in a range.

For example i have a list of suppliers, of which we issued a questionnaire and noted the questions they failed on, and i am looking to find out which of the questions they failed on the most, 2nd most, and then 3rd most. I think i might need to join to formulas together such as MAX/OFFSET but i cant seem to make them work.

Any help or advise would be greatly appreciated, have attached a sample workbook as well.

Here, try this in B3 and extend right and down:

Formula:

Please Login or Register  to view this content.

confirmed with ctrl+shift+enter (not just enter)

I think you have put wrong column.
Wherever you are in your workbook this value is always at A column (row number is not important):

Formula:

Please Login or Register  to view this content.

Hi,

I have updated the formula to show the offset in columns as the live work book requires the information in column M, and it has worked!

Took me a while to understand the formula is working around my integer values, its quite a smart formula!

Thanks very much for your help!

I was aware of that but didn't work on it.
You don't need choose and helper columns. A simple column calculating will do the trick:

Formula:

Please Login or Register  to view this content.