Picking out the name and score of the highest scorer

Hi guys,

Very quick question :-

I have a column of names in column A and respective scores next to them in column B


I want to display the name AND scores for the top 3 people in this list, in another area of the sheet

I have tried using the Index command which pulls out the name, but i cant seem to get the score aswell...

Many thanks

Originally Posted by DonkeyOte

If top 3 names to go in say C2:C4 with socres in D2:D4 then

Please Login or Register  to view this content.

The above will cater for duplicity of scores

that is fantastic thankyou very much!

Hi, I have tried the formula above...

the D column works fine, however i get a circular reference error in the C column and just get 0 when i drag down..


A B C D

jimmy 50 0 89
anna 12 0 50
gotty 4 0 12
ollie 3 0 4
pete 89 0 3

any ideas mate?

Still could not get it sorry.

I have uploaded the file,

Many thanks for your help!

Originally Posted by DonkeyOte

Apologies for delay - was on a call - see attached (note point: re starting results in row 2)

If you avoid use of header row you will need to revert to an Array to handle possibility of duplicate scores or utilise helper cells.

Thats brilliant! thanks again for your help

Sorry to dig up an old thread, but when I try this formula, there seams to be a problem with multiple people scoring the same score. It lists only the first name the formula finds for that particular score...is there anyway to fix this.

Thanks.

Leigh.

Originally Posted by jimmymcmahon

Still could not get it sorry.

I have uploaded the file,

Many thanks for your help!

i have checked the file but the name cell is still showing "0"