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