7 Copy the Faculty sheet , place the copied worksheet to
10.000 the right of the Faculty sheet , and then rename the duplicate worksheet Rooms .
8 Sort the data in the Rooms sheet by Room in ascending
5.000 order , then by Days using the custom sort order you created in step 5 , and finally by Start Time from earliest to latest time . Delete the ID , Course Number , and Instructor columns in the Rooms sheet .
9 Copy the Rooms sheet , place the copied worksheet to
10.000 the right of the Rooms sheet , and then rename the duplicate worksheet Prime Time .
10 Filter the table in the Prime Time sheet to show only
6.000 classes scheduled on any combination of Monday , Wednesday , and Friday . Do not include any combination of Tuesday or Thursday classes though .