Ever wanted to set up “no duplicate values” type of data validation rule in Excel? In this video, learn how to EASILY create such validations.

1) No duplicates allowed with an error message
2) A self shrinking list that removes pre-selected items as you enter data

Sample file:
=========
https://chandoo.org/wp/wp-content/uploads/2021/06/no-duplicates-allowed.xlsx

Timestamps:
===========
0:00 – Introduction
0:34 – No duplicates allowed with an error message
2:31 – Adding custom error message
2:55 – Shrinking list method

Your FREE Excel Tips Book
======================
👉👉👉 https://chandoo.org/wp/subscribe/ 👈👈👈

More Data Validation Goodness 😋🍪
===============================
Two-level data validation – https://youtu.be/Cdofr_SC9io
Remove duplicates when creating validation list – https://youtu.be/4Rv5twNqrGM

About FILTER() formula
===================
Video on DA formulas – https://youtu.be/ONaS7IMKJPM
Article – https://chandoo.org/wp/dynamic-array-functions/

#ExcelTips