Two interesting data validation tricks in Excel

Two interesting data validation tricks in Excel

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

Leave a Reply

Close Menu