Return maximum number name

[skr971]

Hi all,

i need a little problem in excel, i have a raw data like this :

Name	Number
AA	2
BB	3
CC	4
DD	1
Ans.	CC

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

i need a formula which is pick greater number in "number Column" and return the Name as mentioned above

plz suggest if any one knows.

Regards
Skr

 

[Rick Rothstein]

For the header and data shown, give this formula a try...

=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0))