I work at a high school and we are in the process of scheduling. I have a spreadsheet that includes the course requests for about 70 of our students who will be most difficult to schedule. Each students' row includes seven to eight columns, each course request in a column.
I would like to do the following:
For a given course code (example- Algebra 1), I want to know how many students have requested both that course and any other course. How many students have a request for Algebra 1 and English 1? How many students have a request for Algebra 1 and Keyboarding? How many students have a request for Algebra 1 and Biology? After I'm done w/Algebra 1, I'd need to do the same for every course.
I know this is complex and might require multiple steps, just wondering if it is possible in excel.
I am unable to post a link to a google spreadsheet with the document I'm using since I just joined, but can provide upon request.
Bookmarks