All
Search
Images
Videos
Shorts
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
Data validation specific characters only
To use data validation to allow a list of specific characters only, you can use a rather complicated array formula based on the COUNT, MATCH, and LEN functions. In the example shown, data validation is applied with this formula: =COUNT(MATCH(MID(B5,ROW(INDIRECT("1:"&LEN(B5))),1),allowed&"",0))=LEN(B5) where "allowed" is the named range D5:D11.
May 13, 2024
Data Validation Tutorial
10:15
How to use Data Validation in Microsoft Excel Tutorial - Lesson 19
YouTube
The Teacher
7.4K views
Dec 11, 2018
Data Validation: Overview, Types, How to Perform | Built In
builtin.com
11 months ago
2:02
How to use data validation in Microsoft Excel
YouTube
QA
74.8K views
Jan 24, 2013
Top videos
VLOOKUP & INDIRECT – Dynamic Range - Excel & Google Sheets
automateexcel.com
Feb 8, 2023
Dynamic worksheet reference
exceljet.net
May 12, 2024
8:57
MS Excel - Consolidation
YouTube
TutorialsPoint
1.3M views
Jan 15, 2018
Excel Tips and Tricks
0:04
excel tips and tricks (@excelquicktricks)’s videos with original sound - excel tips and tricks
TikTok
excelquicktricks
9.9K views
May 10, 2021
0:11
Essential Excel Tips and Tricks for Efficiency
TikTok
ms.excelmastery
101.7K views
Feb 8, 2025
0:19
Top Excel Tricks to Enhance Your Productivity
TikTok
ms.excelmastery
298.5K views
8 months ago
VLOOKUP & INDIRECT – Dynamic Range - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
Dynamic worksheet reference
May 12, 2024
exceljet.net
8:57
MS Excel - Consolidation
1.3M views
Jan 15, 2018
YouTube
TutorialsPoint
11:02
MS Excel - Data Validation
1.6M views
Jan 15, 2018
YouTube
TutorialsPoint
8:22
INDIRECT Function Excel - A How to Guide
6.6K views
Jun 14, 2021
YouTube
GoSkills.com
3:50
Excel Create Dependent Drop Down List Tutorial
1.4M views
Jun 17, 2017
YouTube
TEKNISHA
3:21
How to Lock Cells in Excel
1.6M views
Mar 27, 2019
YouTube
Excel Tutorials by EasyClick Academy
2:02
How to use data validation in Microsoft Excel
74.8K views
Jan 24, 2013
YouTube
QA
7:01
Excel Dynamic Arrays (How they will change EVERYTHING!)
779.3K views
Oct 18, 2018
YouTube
Leila Gharani
15:49
Better cascading drop-down lists in Excel
69.7K views
Feb 16, 2015
YouTube
Neil Firth
6:14
Lock Cells and Protect Sheets in Excel
813.6K views
Jun 4, 2012
YouTube
Six Minutes. Smarter.
49:42
Excel Cell References 15 Examples Formulas, Conditional Formatting
…
601.9K views
Nov 6, 2009
YouTube
excelisfun
4:58
Different Drop Down Lists in Same Excel Cell
420.8K views
Aug 8, 2010
YouTube
Contextures Inc.
5:53
INDIRECT Excel Function: How it works and when to use it [Advanc
…
43.2K views
Oct 27, 2017
YouTube
365 Data Science
9:47
Creating Excel Dropdowns using Data Validation and Indirect Functi
…
30.2K views
Jan 12, 2020
YouTube
dataexplorer
1:15
How to apply data validation to cells in Microsoft Excel
537.6K views
Mar 8, 2021
YouTube
Microsoft 365
13:48
Excel 2010 Tutorial For Beginners #3 - Calculation Basics & Formula
…
1.5M views
Nov 16, 2012
YouTube
MotionTraining
14:03
Excel INDIRECT Function Explained | Step by Step Excel INDIRECT Tut
…
95.9K views
Nov 19, 2020
YouTube
Innozant
15:42
Create SMART Drop Down Lists in Excel (with Data Validation)
1M views
May 10, 2018
YouTube
Leila Gharani
3:10
How to Create Dynamic Dropdown list with a Table in Excel
45.2K views
Jan 8, 2019
YouTube
Excel Exercice
12:35
INDIRECT Dependent Dynamic Drop Down List | How to create Dynami
…
77.6K views
Nov 26, 2020
YouTube
Innozant
2:34
Drop Down based on another cell | Dependent Data validation | Micro
…
61.8K views
Oct 10, 2017
YouTube
MITutorials
22:50
Quickly make a correlation table in excel - 6 different methods
6.4K views
Mar 27, 2019
YouTube
Karina Adcock
11:57
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)
2M views
Mar 26, 2020
YouTube
Leila Gharani
4:41
How to make a data connection between two Excel workbooks
1.2M views
Sep 23, 2016
YouTube
The AI Strategist
3:42
How to Make a Cell Turn a Color in a Formula in Excel : Using Microsof
…
1.2M views
May 11, 2013
YouTube
eHowTech
5:07
How to fix the #REF error in Excel
45K views
Apr 19, 2021
YouTube
Pete - HowToAnalyst
6:48
How to Create Drop down List With Auto Price List Excel 2020 | Data V
…
172.8K views
Apr 25, 2020
YouTube
Shohoz life
8:46
Create Dynamic Drop-Down Lists Based on Numbers Using INDEX (
…
145.1K views
Mar 15, 2017
YouTube
Leila Gharani
See more videos
More like this
Feedback