Hi Sasikiran,
One method of achieving the goal might be to use a Filtered List
Excel Filters -- AutoFilter Tips
http://www.contextures.com/xlautofilter02.html

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Sasikiran" wrote in message ...
Hello,

I have a formula =INDEX(C4:C33,MATCH(MAX(E4:E33),E4:E33,0 which looks for
the maximum value in the range E4:E33 and displays the name of the person
which is equivalent in the range C4:C33.

C4:C33 has names and their respective values are there in range E4:E33.

The problem is if the max value is the same for two or more persons.

Please let me know how can the formula be changed that it shows all the
names if the max value is same for 2 or more persons.

Thanks in advance
Sasikiran