How to find the highest name in an alphabetic list?

V

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
 
D

Don Guillett

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

Grd

Thanks Kostis

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

Thanks for your help
 
D

Don Guillett

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