On my data, one person just for one date on the same date.
How to prevent input duplicate name on the same date?
for the explanation. please, look the pic below.
duplicate.jpg
On my data, one person just for one date on the same date.
How to prevent input duplicate name on the same date?
for the explanation. please, look the pic below.
duplicate.jpg
Last edited by putritersenyum; 03-15-2016 at 06:13 AM.
Please post a small sample Excel file as many of us cannot view PNG images plus the file provides data to test any formulae against.
You can use data validation to do this.
Select the entire range B1:B7
Goto the Data tab>Data Validation
Allow: Custom
Formula: =COUNTIFS(A$1:A1,A1,B$1:B1,B1)=1
You can include custom input/error messages if desired.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks Tony Valko it works
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks