I've my column in format dd/mm/yyyy and I would like to sort them by date. But I can't find any way of sorting the column by date. If I Sort Ascending, it doesn't recognise that the rows have the date formats. Any easy way of doing that?
How to sort column by date in Numbers
numberssort
Related Solutions
There may be a third-party way to do this I haven't heard of, but there is no way to achieve what you want here using native OS X settings.
Thanks to your sample file, I think I was able to do what you wished.
Using an additional column to bring in the numbers corresponding to the codes (16AA, 1; 16AE, 2...) sorting by that column then hiding it the desired result was accomplished. To refresh the sort after adding data, unhide the column and sort again.
Here are the steps:
Create new column to the left of the "Code" column.
Add a formula to extract the proper number for each code and copy down.
Formula:
=INDEX (Group::c, MATCH (B, Group::A))
(Using INDEX(MATCH) is a good way to get column data with out worrying about extra columns being added as is the case with VLOOKUP.)
- Copy the formula down, sort the column and hide it if desired.
Result:
Best Answer
Your dates might not be recognized as dates by Numbers.
In my case, Numbers does not offer dd/mm/yyyy as one of the standard date format and I have to define a custom format for that pattern. (Not sure, if that applies in your case: The date must be entered according to your locale settings - I can set "dd/mm/yyyy" as the date format, but I have to enter it as "dd.mm.yyyy" on my German system.)
Using the sort & filter window then works well on the formatted dates.