Hello, I am looking for a way to make an alert for a user if they paste a duplicate number into a column. Something that states 'duplicate number in column c'. I have looked into the basic functions in excel for manually entering in the number, pasting over-rides the function. Thank you all for your help in advance.
Try data validation with a custom formula,
Select the entire column C > Data (ribbon) > Data Validation > Select "Data Validation..." > Allow: "Custom" and type in the formula:
=AND(ISNUMBER(C1),COUNTIF(C:C,C1)=1)
for unique numbers (only).
Cheers,
berlan
EDIT: you also need to edit the "Error Alert" under the data validation, if not "Stop"(as default) then change to "Warning" with an error message...
Last edited by berlan; 10-19-2015 at 06:30 PM.
Pasting bypasses DV rules, so perhaps set up another cell somewhere that will alert you to a duplicate entry/pasting?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks