Do you have a data entry form in Excel and want to set up "no duplicate values" type of data validation rule? In this video, learn how to EASILY create such validations, so you get proper data in.
1) No duplicates allowed with an error message
2) A self shrinking list that removes pre-selected items as you enter data
Sample file:
=========
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
======================
👉👉👉 chandoo.org/wp/subscribe/ 👈👈👈
More Data Validation Goodness 😋🍪
===============================
Two-level data validation - youtu.be/Cdofr_SC9io
Remove duplicates when creating validation list - youtu.be/4Rv5twNqrGM
About FILTER() formula
===================
Video on DA formulas - youtu.be/ONaS7IMKJPM
Article - chandoo.org/wp/dynamic-array-functions/
#ExcelTips
- Stop duplicate data entry with these two EASY methods in Excel ( Download)
- Prevent Duplicate Entries in Excel - Tutorial ( Download)
- Stop Duplicate Value Entries in MS Excel (Easy) ( Download)
- Prevent Duplicate Entries in Excel (2 Simple Ways) ( Download)
- Three EASY Ways to Find and Remove Duplicates in Excel ( Download)
- How to Prevent Duplicate Entries in Excel ( Download)
- Excel: Prevent Duplicate Entries in a Column ( Download)
- Excel Pro Trick: Prevent Duplicate Data Entries In Excel with Custom Data Validation and COUNTIF ( Download)
- How to Remove duplicates in excel | Highlight duplicate values in excel | Excel tips & Tricks ( Download)
- How to Find Duplicates in Excel & Highlight Duplicates If You Need To ( Download)
- Find Duplicate Entries in Excel ( Download)
- Prevent Duplicate Entries in Excel Column ( Download)
- Duplicate values in excel, how to prevent! Let’s see easy formula #exceltips #exceltutorial #excel ( Download)
- Prevent Duplicates when Entering Data into Excel ( Download)
- Prevent Duplicate Entries in excel Automatically | Excel Automations | ( Download)
