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!