Data: Custom Sort Criteria
What Do You
See? Spreadsheets are used for financials and financials are
recorded by date. Spreadsheets like Excel recognize that Months are sorted
in calendar order, not alphabetically. Here are the steps:
6.
Try it: Choose a Custom List
Select the spreadsheet.
Go to Data -> Sort &
Filter ->Sort.
Go to
Order-> Custom List.
Select:
January, February, March, April...
This is the
List that matches our data.
Click OK,
then OK again to save and close both windows. The entire list has been sorted. Not bad, huh?
Keep going....
The Computer Mama sez:
In the 1980s, Fr. Paul wanted to sort 550
families on a PDP 11 computer. It took most of the night.
Computers are
faster now, aren’t they?