Another way which is slightly shorter given that it won't return errors and
it will still return the correct values if you insert rows above the formula
and it also return the values in the order from top to bottom

=IF(ROWS(E$4:E4)<=SUM(N($E$4:$E$22=MAX($E$4:$E$22) )),INDEX($C$1:$C$22,SMALL(IF($E$4:$E$22=MAX($E$4:$ E$22),ROW($E$4:$E$22)-ROW($A$1)+1),ROWS($E$4:E4))),"")



--


Regards,


Peo Sjoblom




"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