Checking if Scheduled names dont clash with same day time in a range

**How How** · 07-12-2013, 10:01 AM

Hi,
I'm trying to work out how to check if a players name is due to play on the same rink twice, then if the rink is double booked (day / time). I've attached an example as I'm finding if difficult to explain. Not sure if a formula or VBA would be needed?

Hope someone can help

**Ace_XL** · 07-12-2013, 09:18 PM

In H5
=IF(OR(SUMPRODUCT(($B$5:$C$10=B5)*($F$5:$F$10=F5))>1,SUMPRODUCT(($B$5:$C$10=C5)*($F$5:$F$10=F5))>1),"Not Ok","Ok")

In I5
=IF(OR(SUMPRODUCT(($B$5:$C$10=B5)*($D$5:$D$10=D5)*($E$5:$E$10=E5))>1,SUMPRODUCT(($B$5:$C$10=C5)*($D$5:$D$10=D5)*($E$5:$E$10=E5))>1),"Not Ok","Ok")

In J5
=IF(SUMPRODUCT(($F$5:$F$10=F5)*($D$5:$D$10=D5)*($E$5:$E$10=E5))>1,"Not Ok","Ok")