Prevent Duplicate Entries in Excel with Data Validation
You can prevent duplicate entries from creeping into an Excel worksheet when you protect selected cells with Data Validation.
In this case, you write a Formula that will return either TRUE or FALSE as the answer - i.e. you create a "logical formula." Watch this tutorial as I walk you through each step.
I also show you how to identify "existing" duplicate values in a data set - once again, using Data Validation.
Please visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video tutorials and to sample the many resources that I offer.
Danny Rocks
The Company Rocks
Watch video Prevent Duplicate Entries in Excel with Data Validation online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 08 September 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 108,749 once and liked it 415 people.