spudulene
New member
- Joined
- Aug 20, 2019
- Messages
- 20
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel 2019
I apologize, but I am new here and my thread has not appeared yet. I am sorry if I am sending this multiple times.
I am a professor and I want to correlate multiple student schedules to see when there are the fewest number of conflicts.
Count is important. Below on the right are the data that would be used to populate the table on the left.
I have created the table on the left manually, so one can see what it should look like after using the formula.
For example, there are two times on the right that cover T(uesday) from 8:30 - 8:45. The full spreadsheet would go from 8:00 am - 5:00 pm and have a couple hundred days, start and end times.
I would consider myself and intermediate excel user. I tried multiple attempts using countifs statements, but could not get past the first row of input data. Any help would be appreciated.
I am a professor and I want to correlate multiple student schedules to see when there are the fewest number of conflicts.
Count is important. Below on the right are the data that would be used to populate the table on the left.
I have created the table on the left manually, so one can see what it should look like after using the formula.
For example, there are two times on the right that cover T(uesday) from 8:30 - 8:45. The full spreadsheet would go from 8:00 am - 5:00 pm and have a couple hundred days, start and end times.
I would consider myself and intermediate excel user. I tried multiple attempts using countifs statements, but could not get past the first row of input data. Any help would be appreciated.
Time | Day | Days | Start | End | ||||||||
M | T | W | R | F | TR | 8:00 | 9:00 | |||||
8:00 | 0 | 1 | 0 | 1 | 0 | W | 9:20 | 9:45 | ||||
8:15 | 0 | 1 | 0 | 1 | 0 | MWF | 9:00 | 9:50 | ||||
8:30 | 0 | 2 | 0 | 1 | 0 | T | 8:30 | 8:45 | ||||
8:45 | 0 | 2 | 1 | 1 | 1 | WF | 8:45 | 9:45 | ||||
9:00 | 1 | 1 | 1 | 1 | 2 | |||||||
9:15 | 1 | 1 | 2 | 1 | 2 | |||||||
9:30 | 1 | 1 | 2 | 1 | 2 | |||||||
9:45 | 1 | 1 | 0 | 1 | 1 |