Warning about duplicate entries

seguin85

Active Member
Hi,

I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such:
ABCDEFGHIJKLMN
1NameJob#Loc6/256/266/276/286/296/307/17/27/37/47/5
2John AX34USADDDDDDDDD
3JoeV45CANNNNNNNNN
4John AV45CANDDDD
5JenX34USAAAAAAAAA

<tbody>
</tbody>













I would like some type of conditional formatting or an alert box to pop up if someone is double booked. From this example John A is double booked from 7/2 - 7/5. So if it has the same name and >=2 entries on the same date I would like some type of warning. I know some vba if that would provide an easier solution.

Thanks!
 

Some videos you may like

This Week's Hot Topics

Top