Timetable Clashes

DreamerROC

New Member
Joined
Oct 21, 2017
Messages
1
Hello Everyone,

I am a teacher and my school timetable changes weekly. I am trying to write a formula to check that my timetable does not clash with other classes. I teach accounting. There is a master timetable with all the subjects for one group of students, then the subject timetable are extracted from there and appear on the worksheets that follow the master sheets.

For my subject the master timetable says ACC for accounting. The subject timetable says G1 and G2 for group 1 and group 2 classes. The master timetable corresponds to the cell references on the subject timetables.

Here is the link to timetable:

https://1drv.ms/x/s!Aq3sBqqA2N8xoT4oXpNuqpCJduh1

PS. I do not know how to attach it here.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top