Whether I sort using the individual column or the sort function I get two lots of months. By that I mean it goes from Jan to December then Jan to December again in the same column.
I am using Numbers on mac
iMac, iOS 10.2.1
Change the format back to "Automatic" (or use undo to get back to the column formatted as "Automatic or Date")
you can add another column named "Month Number" in the example below:
B2=MONTH(A2)
this is shorthand for... select cell B2, then type (or copy and paste from here) the formula:
=MONTH(A2)
to fill down, select cell B2, copy
select cells B2 thru the end of column B, or as needed, paste
now sort on "Month Number" rather than the name
There are no replies.
Numbers will not sort months correctly
