2 Sort the values in the Campus column using a custom
9 sort order list. Use the following order: Hilltop, Lower County, and then East.
3 Sort the Group column in ascending order as a second
6 level sort in the table, and then sort the Program Name column in ascending order as a third level sort in the table.
4 Convert the table to a range. 4
5 Display the Schedule Comparison worksheet. Name the
9 range A2: F3 using the name Criteria. Name the range A6: F15 using the name Database, and then name the range A19: F19 using the name Extract.
6 In cell D3, type Spring and in cell E3, type Summer.
8
Create an advanced filter that will copy all records from the Database range with Spring as their primary season