Posted to microsoft.public.excel.worksheet.functions
|
|
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
|