Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting problem 10 comes before 8
When sorting a list in a column where some are single digits and some are
such as : 1 3 8 8 x 12 10 x 10 they sort as follows 1 3 8 10 x 10 8 x 12 single numbers are fine but once you hit the ones with the x (to show measurements) the 1 in the 10 x 10 comes before the 8. It does not help to make it text. Any thoughts |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with sorting | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
Not Sorting Problem? | Excel Worksheet Functions | |||
Sorting problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Worksheet Functions |