Hi,

Just needing some help with checking some logic on a web based scheduling system. Need to verify the results in Excel to see the system is taking the constraints into account correctly. Scenario is

Candidates for an exam can request to sit the exam with certain people to save on travel costs e.t.c and also to specify dates they are not available to sit the exam on. So a file is loaded into the system like attached.

We need to verify the outcome using Excel to check that the candidates are not scheduled to sit an exam on a date they have said they are not available but also that they are scheduled to sit the exam with any travel partners they have specified. I know how to check the first bit for the dates, having issues with the second bit of checking that the candidates are scheduled together. Any ideas how I might check for this?

Thanks

scheduling.png