|
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
![]() ![]() ![]() ![]()
Difficulty: Intermediate
Video: Yes |