IanJohnson
New Member
Hi,
I am hoping someone might be able to provide some input. I have a project that spans over a number of regions. Within each region there are specified dates where workshops are held. I am wanting to create an excel workbook that identifies where potential clashes could be if we wanted to allocate one individual to more than one region. In other words, if the region was Paris and we also wanted the individual to cover Lyon, I would need to know if the dates clashed for meetings i.e are there any meetings on the same date in Paris as Lyon which would prevent them being staffed to that area. Any suggestion on layout, formulas etc? Many thanks.
I am hoping someone might be able to provide some input. I have a project that spans over a number of regions. Within each region there are specified dates where workshops are held. I am wanting to create an excel workbook that identifies where potential clashes could be if we wanted to allocate one individual to more than one region. In other words, if the region was Paris and we also wanted the individual to cover Lyon, I would need to know if the dates clashed for meetings i.e are there any meetings on the same date in Paris as Lyon which would prevent them being staffed to that area. Any suggestion on layout, formulas etc? Many thanks.
