i have found this code: =COUNTIF($A$1:$A$20,A1)=1
which when using 'data validation' works great to prevent duplicate values.
I however want the opposite. I want it to warn the user if they are adding a new value that is not already in column...
any thoughts?? can't find this anywhere!!
Maybe change it to >1?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
How about.
=COUNTIF($A$1:$A$20,A1)<1
If that doesn't help we need an uploaded Excel file (not a pic or screen shot ... we need context).
If you aren't familiar with how to do this:
To attach a file to your post,
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
Dave
Both worked a treat. thank you!!
Happy to help and thanks for the feedback
Same here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks