ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,251
- Office Version
- 2007
- Platform
- Windows
Hi,
I need a basic check for duplicate entries.
Each day i enter a customers name into cell A4 then when i leave the cell i wish the code to check to see if there is a duplicate in my current range of which is A4:A149
I have used data validation as so,
Select all cells in question A4:A150
Data validation
Allow = Custom
Formula =COUNTIF($A$4:$A$149,A4)=1
My problem is i get a false alert for when a new name is entered and does not exist in my range.
Please can you see where i went wrong.
On a side not as i enter names into A4 each day and the list becomes longer will the formula in data validation auto update itself ?
If you think i am better off using VBA etc then no problem please advise.
Many Thanks
I need a basic check for duplicate entries.
Each day i enter a customers name into cell A4 then when i leave the cell i wish the code to check to see if there is a duplicate in my current range of which is A4:A149
I have used data validation as so,
Select all cells in question A4:A150
Data validation
Allow = Custom
Formula =COUNTIF($A$4:$A$149,A4)=1
My problem is i get a false alert for when a new name is entered and does not exist in my range.
Please can you see where i went wrong.
On a side not as i enter names into A4 each day and the list becomes longer will the formula in data validation auto update itself ?
If you think i am better off using VBA etc then no problem please advise.
Many Thanks