Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
Hi,
I tried using the max function to find the highest name eg Zachary but it only seems to work with numbers. I am I doing something wrong? Is there some function to find the highest name in a list of names. Its driving me crazy. Any help greatly appreciated. Thanks Sandra |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
On Tue, 14 Mar 2006 08:23:09 -0800, Grd wrote:
Hi, I tried using the max function to find the highest name eg Zachary but it only seems to work with numbers. I am I doing something wrong? Is there some function to find the highest name in a list of names. Its driving me crazy. Any help greatly appreciated. Thanks Sandra What do you mean by "highest"? If you mean the text string that will sort last in an Excel text sorted range, then one way would be to download and install Longre's free morefunc.xll add-in from http://xcell05.free.fr Then use the formula: =VSORT(rng) --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
thanks ron
s "Ron Rosenfeld" wrote: On Tue, 14 Mar 2006 08:23:09 -0800, Grd wrote: Hi, I tried using the max function to find the highest name eg Zachary but it only seems to work with numbers. I am I doing something wrong? Is there some function to find the highest name in a list of names. Its driving me crazy. Any help greatly appreciated. Thanks Sandra What do you mean by "highest"? If you mean the text string that will sort last in an Excel text sorted range, then one way would be to download and install Longre's free morefunc.xll add-in from http://xcell05.free.fr Then use the formula: =VSORT(rng) --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
Try...
=INDEX(A2:A10,MATCH(0,IF(A2:A10<"",COUNTIF(A2:A10 ,""&A2:A10)),0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , Grd wrote: Hi, I tried using the max function to find the highest name eg Zachary but it only seems to work with numbers. I am I doing something wrong? Is there some function to find the highest name in a list of names. Its driving me crazy. Any help greatly appreciated. Thanks Sandra |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
Thanks this is what i was after. Works nicely
s "Domenic" wrote: Try... =INDEX(A2:A10,MATCH(0,IF(A2:A10<"",COUNTIF(A2:A10 ,""&A2:A10)),0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , Grd wrote: Hi, I tried using the max function to find the highest name eg Zachary but it only seems to work with numbers. I am I doing something wrong? Is there some function to find the highest name in a list of names. Its driving me crazy. Any help greatly appreciated. Thanks Sandra |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
Domenic wrote...
Try... =INDEX(A2:A10,MATCH(0,IF(A2:A10<"",COUNTIF(A2:A1 0,""&A2:A10)),0)) ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. .... You could shrink that to the nonarray formula =LOOKUP(2,1/(COUNTIF(A2:A10,""&A2:A10&"*")=0),A2:A10) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find highest alphabetic name in a list of names
Thanks Harlan! Very interesting...
In article .com, "Harlan Grove" wrote: Domenic wrote... Try... =INDEX(A2:A10,MATCH(0,IF(A2:A10<"",COUNTIF(A2:A1 0,""&A2:A10)),0)) ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. ... You could shrink that to the nonarray formula =LOOKUP(2,1/(COUNTIF(A2:A10,""&A2:A10&"*")=0),A2:A10) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a formul | Excel Discussion (Misc queries) | |||
5 highest then list names | Excel Worksheet Functions | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |