Excel Forum

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

This Microsoft Excel video tutorial shows you how to make a list in excel where duplicate values cannot be entered. This means that only unique values, characters, words, etc. will be allowed to be entered into this list.

This is a neat trick using data validation which will help you to prevent user errors when filling out excel spreadsheets.
   Topics Covered
Prevent Duplicate Values Being Entered in a List
Allow only Unique Values in a List in Excel
Custom Data Validation
COUNTIF() Function
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.