Excel VBA Tips
Search This Blog
Monday, 13 August 2012
DATA VALIDATION FOR RESTRICTING DUPLICATE VALUES
Select cell A7 and go to
Data Tab
, Click on
Data Validation
, select
Custom
in Allow field and enter formula in formula field as shown below (Click to enlarge)
Formula: =ISNA(VLOOKUP(A7,A2:A6,1,FALSE))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment