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 wanted to look up the last entry in a column of figures, Googled and found your piece. After a bit of fiddling to understand what was going on it worked brilliantly! Magic! -Rachel
