1st 2nd and 3rd place

[emmatm]

Hi,

I have an excel table which displays a name in column B and a score in column L. I then have a cell in L29 where I want to display the name of the person with the highest score and cell L30 the name of the person in 2nd place and then finally cell L31 showing the person in 3rd place.

Thanks

 

[rahulshewale1]

hii emmatm,

please find the attached solution . is it meet your requirement. please let me

 

[vletm]

one possible ...
formula for L29
=LOOKUP(LARGE(L$1:L$28;1);L$1:L$28;B$1:B$28) & " " & LARGE(L$1:L$28;1)
change red values as rank for cells L30 & L31

 

[rahulshewale1]

HII

if the score data value has duplicate u can use index+aggregate formula.

please check Solution

 

[emmatm]

Thanks - I have just checked this formula if there are 2 people with the exact same score

one possible ...
formula for L29
=LOOKUP(LARGE(L$1:L$28;1);L$1:L$28;B$1:B$28) & " " & LARGE(L$1:L$28;1)
change red values as rank for cells L30 & L31

I am getting an error on this - could you check please?

 

[NARAYANK991]

Hi ,

Try replacing the semi-colon by a comma , since these are separators which vary according to the language version of Excel.

Narayan

 

[emmatm]

HII

if the score data value has duplicate u can use index+aggregate formula.

please check Solution

HII

if the score data value has duplicate u can use index+aggregate formula.

please check Solution

Hi it worked on one but note all 3 - if my rows start from 8 down to 27 would the formulas given still stay the same?

 

[emmatm]

Thanks - I have just checked this formula if there are 2 people with the exact same score


I am getting an error on this - could you check please?

This is combining the name and the value together from cells B & L - I only want the name from column B to be shown

 

[vletm]

Hmm.. You wrote:
I then have a cell in L29 where I want to display the name of the person with the highest score...and now You want something else ...
You have to take this part & " " & LARGE(L$1:L$28;1) away

 

[emmatm]

Hmm.. You wrote:
I then have a cell in L29 where I want to display the name of the person with the highest score...and now You want something else ...
You have to take this part & " " & LARGE(L$1:L$28;1) away

Ah I see - I meant I wanted the name of the person to show who had the highest score not with the highest score! sorry for the confusion.

 

[vletm]

One more try ...
You wanted the name of the person to show who had
the highest score to cell L29,
2nd highest name to L30 and
3rd highest scores to L31.
=> Press the [Button]