There's an issue with that formula.
It only uses the ASCII code for the first character in the cell.

That would be a problem in this list
Fred
Ben
Karla
Zack
Zane

The formula would return "Zack" instead of "Zane".
***********
Regards,
Ron

XL2002, WinXP


"Teethless mama" wrote:

=INDEX(A1:A5,MATCH(MAX(CODE(UPPER(A1:A5))),CODE(UP PER(A1:A5)),0))

ctrl+shift+enter, not just enter


"Carlo" wrote:

Hi there,

I have a list of names like Andrew, Zachary, Jeff etc and I need to find out
which one is the highest alphabetically. The max function doesn't seem to
work.

Is this possible?

Thanks

Carlo