How to find the highest name in an alphabetic list?
 

The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne

How to find the highest name in an alphabetic list?
 

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

On Jul 3, 5:42 pm, Grd wrote:
The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne

How to find the highest name in an alphabetic list?
 

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

"Grd" wrote in message
...
The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne

How to find the highest name in an alphabetic list?
 

Thanks Don,

This works for me

"Don Guillett" wrote:

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

"Grd" wrote in message
...
The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne

How to find the highest name in an alphabetic list?
 

Thanks Kostis

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

Thanks for your help

"vezerid" wrote:

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

On Jul 3, 5:42 pm, Grd wrote:
The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne

How to find the highest name in an alphabetic list?
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Grd" wrote in message
...
Thanks Don,

This works for me

"Don Guillett" wrote:

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

"Grd" wrote in message
...
The max function doesn't seem to work.

could anyone help me out

Tx

Suzanne