21 Data Validation Formula Examples

Working Excel formulas for data validation, with detailed explanations, videos, and related links. Includes formulas to validate dates, text, numbers, unique values, and more. See all Excel formulas.

Quick Links

Data validation allow letters and numbers only

Data validation allow letters and numbers only

Data validation allow numbers only

Data validation allow numbers only

Data validation allow text only

Data validation allow text only

Data validation allow uppercase only

Data validation allow uppercase only

Data validation allow weekday only

Data validation allow weekday only

Data validation date in next 30 days

Data validation date in next 30 days

Data validation date in specific year

Data validation date in specific year

Data validation don't exceed total

Data validation don't exceed total

Data validation exists in list

Data validation exists in list

Data validation must begin with

Data validation must begin with

Data validation must contain specific text

Data validation must contain specific text

Data validation must not contain

Data validation must not contain

Data validation must not exist in list

Data validation must not exist in list

Data validation no punctuation

Data validation no punctuation

Data validation only dates between

Data validation only dates between

Data validation require specific multiple

Data validation require specific multiple

Data validation require unique number

Data validation require unique number

Data validation specific characters only

Data validation specific characters only

Data validation unique values only

Data validation unique values only

Data validation whole percentage only

Data validation whole percentage only

Data validation with conditional list

Data validation with conditional list

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

I love your website! I ran across it a few days ago and being an Excel fan couldn’t help just reading for hours and days even though most of what I was reading had nothing to do with my issue :)

Dennis

More Testimonials