Listing variable names for 3 greatest values in a column?

[Guest]

Hi,
Could anyone help me with a formula to get the specific titles/names from
the 3 greatest values in a column? For example:
colA colB
name a 3
name b 6
name c 1
name d 7
name e 4
So, I would like to list the names of the 3 highest values in column B,
namely:
"name d" (1st highest value)
"name b" (2nd highest value)
"name e" (3rd highest value)
I have about 20 variable names total, all different from one another. Is
this possible? Thanks so much in advance!
Lindsay

 

[Roger Govier]

Hi Lindsay

in Cell C2 enter
=INDEX($A$2:$A$21,MATCH(LARGE($B$2:$B$212,ROW(1:1)),$B$2:$B$21,0))
and copy down

 

[Guest]

Thanks!
That works perfectly!
Lindsay

Hi Lindsay

in Cell C2 enter
=INDEX($A$2:$A$21,MATCH(LARGE($B$2:$B$212,ROW(1:1)),$B$2:$B$21,0))
and copy down

 

[Roger Govier]

Hi Lindsay

You're very welcome. Thanks for the feedback.