Warning about duplicate entries

[seguin85]

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:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]N[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Name[/TD]
[TD="align: center"]Job#[/TD]
[TD="align: center"]Loc[/TD]
[TD="align: center"]6/25[/TD]
[TD="align: center"]6/26[/TD]
[TD="align: center"]6/27[/TD]
[TD="align: center"]6/28[/TD]
[TD="align: center"]6/29[/TD]
[TD="align: center"]6/30[/TD]
[TD="align: center"]7/1[/TD]
[TD="align: center"]7/2[/TD]
[TD="align: center"]7/3[/TD]
[TD="align: center"]7/4[/TD]
[TD="align: center"]7/5[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]John A[/TD]
[TD="align: center"]X34[/TD]
[TD="align: center"]USA[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Joe[/TD]
[TD="align: center"]V45[/TD]
[TD="align: center"]CAN[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"]N[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]John A[/TD]
[TD="align: center"]V45[/TD]
[TD="align: center"]CAN[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Jen[/TD]
[TD="align: center"]X34[/TD]
[TD="align: center"]USA[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]A[/TD]
[/TR]
</tbody>[/TABLE]













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!

 

[Fluff]

How using CF with this formula
=COUNTIFS($A$2:$A$5,$A2,D$2:D$5,"<>")>1

 

[seguin85]

Great! That worked perfectly!

 

[Fluff]

You're welcome & thanks for the feedback