Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare string
Hi,
I want to find the min string within several strings. For example, the string group include "2008wk32", "2008wk12", "2008wk01". I need find the min string as "2008wk01". I tried to use if(ABAC, AB, AC), but I need use this for many time to compare all strings, is there any simple methods? Thanks, D.L |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare string
One try ..
Assuming the strings are within B1:E1 In say, A2, array-entered, ie press CTRL+SHIFT+ENTER to confirm: =INDEX(B1:E1,MATCH(TRUE,(MIN(RIGHT(B1:E1,2)+0)=RIG HT(B1:E1,2)+0),0)) Range B1:E1 is assumed fully populated, with the rightmost 2 char numeric. Adapt to suit. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "HugeHard" wrote: I want to find the min string within several strings. For example, the string group include "2008wk32", "2008wk12", "2008wk01". I need find the min string as "2008wk01". I tried to use if(ABAC, AB, AC), but I need use this for many time to compare all strings, is there any simple methods? Thanks, D.L |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
How do I compare string values in one column to another column? | Excel Worksheet Functions |