| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort by placement value from left to right & adding trailing zeros for short
How can I create a sort with helper columns or some other methods to achieve the following?
I would like to sort by evaluating each placement value from left to right and place them in descending order as if they are all the same length of character string... I have tried many helper columns but can't sort exactly as needed. I would like to turn this: 1200 1205 1210 1211 1215 1218 1225 1245 1060-5 114-0-01 114-5-01 115-3-01 116-3-02 116-5-02 117-0-02 117-5-02 120-3-01 120-5-01 121-0-01 121-5-01 1225-3 123-0-01 123-5-01 124-0-01 124-5-01 INTO THIS, once sorted: 1060-5 114-0-01 114-5-01 115-3-01 116-3-02 116-5-02 117-0-02 117-5-02 120-3-01 120-5-01 1200 1205 121-0-01 121-5-01 1210 1211 1215 1218 1225 1225-3 123-0-01 123-5-01 124-0-01 124-5-01 1245 Thank you!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trailing zeros | Excel Worksheet Functions | |||
| Trailing Zeros | Excel Discussion (Misc queries) | |||
| Keep numbers as entered with trailing zeros | Excel Discussion (Misc queries) | |||
| Keep Trailing Zeros When Convert To Text | Excel Discussion (Misc queries) | |||
| Trailing zeros are dropping off | Excel Programming | |||
Threaded Mode
