Hi,
I want to use INDEX to display the name for the maximum value

eg:

Name value

A 5.00
B 6.00
C 7.00
D 8.00
E 9.00
F 10.00


I want to display F as it has the maximum value(which i have got
through MAX function).
How would i achieve that?

Appreciate ur help:)

Harsha


--
harshaputhraya
------------------------------------------------------------------------
harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225
View this thread: http://www.excelforum.com/showthread...hreadid=540177