Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.