|
|
Featured Tutorial
Featured Macro
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.
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 |