Largest Value - Simple Question

[aab2003]

If I have a column of names that corresponds to a column of numbers, i.e.

a 1
b 2
c 3
d 4
e 5
f 6

I know that to find the largest value of the number column the formula is =large(range, kth largest value). But what would be the formula for the 5 largest values in the column? And also, say I want the largest value in the above example, how can I get the letter "f" displayed next to the value "6" that the formula would give me?

Many Thanks. Please respond or e-mail me directly. aab2003@columbia.edu

 

[Aladin Akyurek]

If I have a column of names that corresponds to a column of numbers, i.e.

a 1
b 2
c 3
d 4
e 5
f 6

I know that to find the largest value of the number column the formula is =large(range, kth largest value). But what would be the formula for the 5 largest values in the column?

LARGE(B1:B6,{1,2,3,4,5})

would pick out 5 largest values from B1:B6.

And also, say I want the largest value in the above example, how can I get the letter "f" displayed next to the value "6" that the formula would give me?

=INDEX(A1:A6,MATCH(MAX(B1:B6),B1:B6,0))

 

[Brian from Maui]

Maybe this thread too?

http://www.mrexcel.com/board2/viewtopic.php?p=224930&highlight=rank#224930