Skip to main content
Login
Cart
Exceljet
Quick, clean, and to the point
Training
Videos
Functions
Formulas
Shortcuts
Blog
Data Validation Formula Examples
Examples of formulas you can use to apply data validation in Excel.
See also:
Data Validation Guide
|
Dependent Dropdown Lists
Data validation specific characters only
Data validation no punctuation
Data validation number multiple 100
Data validation whole percentage only
Data validation with conditional list
Data validation unique values only
Data validation must not contain
Data validation must not exist in list
Data validation exists in list
Data validation don't exceed total
Data validation must begin with
Data validation must contain specific text
Data validation allow uppercase only
Data validation allow weekday only
Data validation date in specific year
Data validation date in next 30 days
Data validation require unique number
Data validation only dates between
Data validation allow text only
Data validation allow numbers only
I just wanted to say thank you, because your website has been a great resource for me in my work over the years. The content, design and layout of your site makes it a pleasure to use. I use it most often as a quick reference, but occasionally dive deeper into the explanations to help make the learning stick. -your website has been a great resource for me in my work over the years