6 replies
by amberhaze
One way to do this would be to create 2 hidden temp columns. the first is a function pulling the month, the second the day of the month. You then would simply issue a sort based on these two temp columns...
There are probably more elegant ways of doing it, but the above would take about a minute to set up and be done...
by sgt_shultz
you might be looking to Sort.
Highlight all you data, pick Data (from the text menu along the top of Excel) then pick Sort. you can choose the column to sort by and the sort order (descending/ascending)
by rrbdba
by bschaettle
Remember that "June 15, 1900" is simply the displayed format of the underlying "date" data, unless you stored it as text (hope not).
Sorting it should be easy. On the Excel menubar, click on "Data" then "Sort" and tell it to sort using the column that contains the dates.
by rrbdba
by rrbdba
This discussion is closed to new replies.
Trending Software posts
Sort by Trending