| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting in a cell
I have a very long list which I would like to sort (see first column example)
first by the last two digits and then the 3rd digit, so that the sorted list would appear like column 2. I don't know where to start on this. 2297814 2179312 766961 2297814 2200735 2317528 2113780 2005233 2225041 2200735 604875 2225041 2103953 557042 557042 2272153 738066 2103953 2179312 766961 2272153 738066 2224766 2224766 2317528 604875 2126879 2126879 2005233 2113780 2260982 2260982 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting using a second word in a cell | Excel Discussion (Misc queries) | |||
| sorting a concatenated cell | Excel Discussion (Misc queries) | |||
| Sub-cell List Sorting | Excel Discussion (Misc queries) | |||
| Sorting data at end of cell | Excel Discussion (Misc queries) | |||
| link cell in 1 wk-sht to another & keep it regardless of sorting | Excel Worksheet Functions | |||
Threaded Mode
