On Thu, 10 Nov 2005 11:49:07 -0500, Domenic wrote:

Here's another way...

If Z is higher than Y, try...

=INDEX(A1:A10,MATCH(LARGE(COUNTIF(A1:A10,"<"&A1:A 10),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:A 10),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,


Nice
--ron