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
 
G

Grd

Thanks Don,

This works for me

Don Guillett said:
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)
Click to expand...
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Need to find the higest alpahbetic name in a list of names 11
Highest Values Comparison 4
Highest alphanumeric 6
Formula to find highest alphabetic name in a list of names 6
Trying to find additional ranges outside of min, max, and average 2
Reference the 2nd and 3rd highest in range. 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top