Main Profile

At A Glance

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!
Length: 05:27

Contact

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

Want more info about Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question