![]() |
|
|
|
#1
|
||||
|
||||
|
Your are right, it is a struggle. I tried adding helper columns for size and measurement (mm, ml, g..) but still 23/13 came before 23/6 or 23/06 so the helper columns were discarded. I guess we will have to live with the not so perfect sort results. |
|
#2
|
||||
|
||||
|
If I edited to 23/06 on the List sheet it came out in the correct order on ListSort sheet!
|
|
#3
|
||||
|
||||
|
Ooops. My mistake. Yes, placing a zero before the single digits would sort the data the way they should be sorted. Thank you.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Sort data by month and by dates
|
Marcia | Excel | 4 | 05-30-2018 01:51 AM |
Please Help. I need to sort Data A-Z not sure if i need to use Macros
|
steveyjohn | Excel | 1 | 11-14-2014 06:19 PM |
When I sort my data, the sumif report changes
|
amaka | Excel | 6 | 03-19-2014 04:55 AM |
| sort data in excel | cabot | Excel | 1 | 08-17-2012 09:41 AM |
Sort Data
|
rkeles | Excel | 6 | 02-04-2012 01:31 PM |