G
Grd
The max function doesn't seem to work.
could anyone help me out
Tx
Suzanne
could anyone help me out
Tx
Suzanne
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
=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)
=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
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
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)
D
Don Guillett
Glad to help. The other would have worked IF NO blanks and array entered
using ctrl+shift+enter
using ctrl+shift+enter