Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A1 0),1),COUNTIF(A1:A10,"<
"&A1:A10),0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

If A is higher than B, try...

=INDEX(A1:A10,MATCH(SMALL(COUNTIF(A1:A10,"<"&A1:A1 0),1),COUNTIF(A1:A10,"<
"&A1:A10),0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Calaw" wrote:

Hi,
I have a list of names and I need to get the name with the highest in the
alphabetical order. I dont want to sort.
Thanks,