Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i sort a column numerically going from 01-01 to 225-99
when i sort my column in numerical order, it starts out fine, i.e 01-01,
01-02. However, when it gets to 10-01, i get 10-01, 100-01,100-02, etc, without any rhyme or reason. How do i set to sort 01-nn through 99-nn befor going to 100-nn and beyond |
#2
|
|||
|
|||
how do i sort a column numerically going from 01-01 to 225-99
Excel's help explains it.
I searched for: Default sort orders Apostrophes (') and hyphens (-) are ignored, with one exception: If two text strings are the same except for a hyphen, the text with the hyphen is sorted last. One way around it (maybe???) is to use a helper column with a formula in it. Then sort your data by that helper column. If your data is in A1:Axx, put this in that helper column (row 1): =--SUBSTITUTE(A1,"-",".") And drag down. Then sort by that column. Since the data is now numeric, it should work ok. column sorting wrote: when i sort my column in numerical order, it starts out fine, i.e 01-01, 01-02. However, when it gets to 10-01, i get 10-01, 100-01,100-02, etc, without any rhyme or reason. How do i set to sort 01-nn through 99-nn befor going to 100-nn and beyond -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Highlight Sort Column | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |