Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.

http://www.TeachMsOffice.com This tutorial shows you how to create a list in Microsoft Excel which only contains unique values. This means that a user cannot enter a duplicate value or word or phrase in a list. The words or numbers or characters must be exactly the same to be considered a duplicate entry. This method used the Data Validation technique in excel. The formula/function used here is COUNTIF(). To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions. Have a great day!