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?

Data -> Sort & Filter ->Sort-> Order-> Custom List

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data: Sort data using single or multiple criteria