Listing variable names for 3 greatest values in a column?
 

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

Listing variable names for 3 greatest values in a column?
 

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

--
Regards

Roger Govier


"Lindsay" wrote in message
...
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

Listing variable names for 3 greatest values in a column?
 

Thanks!
That works perfectly!
Lindsay

"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Lindsay" wrote in message
...
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

Listing variable names for 3 greatest values in a column?
 

Hi Lindsay

You're very welcome. Thanks for the feedback.

--
Regards

Roger Govier


"Lindsay" wrote in message
...
Thanks!
That works perfectly!
Lindsay

"Roger Govier" wrote:

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

--
Regards

Roger Govier


"Lindsay" wrote in message
...
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