How to find the highest name in an alphabetic list?

[Grd]

The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne

 

[vezerid]

Say the words are in A2:A15. Use the following formula:

=INDEX(A2:A15,MATCH(TRUE,COUNTIF(A2:A15,">"&A2:A15)=0,0))

This is an array formula. Commit with Shift+Ctrl+Enter.

Change the ">" with "<" if you want to find the "smallest" (i.e.
closest to A). This one will give you the one closest to zzzzz.

HTH
Kostis Vezerides

 

[Don Guillett]

correct for wordwrap
=LOOKUP(2,1/((COUNTIF(A1:A21,">"&A1:A21)=0)*(A1:A21<>"")),A1:A21)

 

[Grd]

Thanks Kostis

Had rouble with this (I was probably doing something wrong). I tried Bobs
answer and it worked .

Thanks for your help

 

[Grd]

Thanks Don,

This works for me

correct for wordwrap
=LOOKUP(2,1/((COUNTIF(A1:A21,">"&A1:A21)=0)*(A1:A21<>"")),A1:A21)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help. The other would have worked IF NO blanks and array entered
using ctrl+shift+enter