| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting the first text in a row
=IF(COUNTA(1:1),INDEX(1:1,MATCH("*",1:1,0)),"")
"Hans" wrote: I have 4 columns with names, in some rows are none to 4 names. The names appear random in any of the columns. It could look like this: name1 name2 name3 name 4 name5 I want to get the first name that appears (from left to right) and put it in the fifth column, like this: name1 name3 name4 I can't figure it out, any help is welcome |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting different strings of text | New Users to Excel | |||
| Sorting (Numbers with Text) | Excel Discussion (Misc queries) | |||
| help with text sorting | Excel Worksheet Functions | |||
| Sorting Text | Excel Discussion (Misc queries) | |||
| sorting of text | Excel Discussion (Misc queries) | |||
Threaded Mode
