Delivery Schedule

[didierkassas]

Hello guys

I have a small issue and not sure how to solve it

i am creating a schedule that will allow people to select the following

Day
Time
Location
Desk

the issue i am facing is i would like the system to show an error in case there are 2 bookings at the same time

i have attached the excel that i have made.

any assistance will be much appreciated.

regards

[Glenn Kennedy]

What do you want to see, and where do you want to see it?

[didierkassas]

On the Tables on the right i would like to see the naming in red, so i know that there is a conflict

and on the table on the left i would like to have the conflict entries in red

[Glenn Kennedy]

First part:

=SUMPRODUCT(($E$16:$E$79=$E16)*($I$16:$I$79=$I16)*($J$16:$J$79=$J16)*($F16<$H$16:$H$79)*($H16>=$F$16:$F$79))>1

see sheet.

[didierkassas]

This like this is perfect

thank you so much

[Glenn Kennedy]

scrap that. it doesn't work...

Fixed using:

=SUMPRODUCT(($E$16:$E$79=$E16)*($I$16:$I$79=$I16)*($J$16:$J$79=$J16)*($F16<$H$16:$H$79)*($H16>$F$16:$F$79))>1

[Glenn Kennedy]

Do you not also want the second part, or is this enough?

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.