Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>
Idioma: En

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))




This post first appeared on Excel VBA Tips, please read the originial post: here

Share the post

DATA VALIDATION FOR RESTRICTING DUPLICATE VALUES

×

Subscribe to Excel Vba Tips

Get updates delivered right to your inbox!

Thank you for your subscription

×