=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