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