Quote:
Originally Posted by MrTown
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!!!
|
If you had a helper column and use the substitute(a1, "-", "*") formula to replace the "-" with "*" and then sort according to this column, this should do the job.
If it still gives you problems let us know