| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find out the 3 highest occurrence of number from a list? | Excel Discussion (Misc queries) | |||
| Finding the highest alphabetic name in a list of names | Excel Worksheet Functions | |||
| HIghest Value - Numeric and Alphabetic | Excel Worksheet Functions | |||
| Formula to find highest alphabetic name in a list of names | Excel Worksheet Functions | |||
| i need a function to find the highest value in a list | Excel Worksheet Functions | |||
Linear Mode
