Data Validation Formula Examples

Data validation can help control what a user can enter into a cell. These formula examples cover commons scenarios you might experience.

Quick Links

Excel formula: Data validation specific characters only

Data validation

Data validation specific characters only

Excel formula: Data validation no punctuation

Data validation

Data validation no punctuation

Excel formula: Data validation require specific multiple

Data validation

Data validation require specific multiple

Excel formula: Data validation whole percentage only

Data validation

Data validation whole percentage only

Excel formula: Data validation with conditional list

Data validation

Data validation with conditional list

Excel formula: Data validation unique values only

Data validation

Data validation unique values only

Excel formula: Data validation must not contain

Data validation

Data validation must not contain

Excel formula: Data validation must not exist in list

Data validation

Data validation must not exist in list

Excel formula: Data validation exists in list

Data validation

Data validation exists in list

Excel formula: Data validation don't exceed total

Data validation

Data validation don't exceed total

Excel formula: Data validation must begin with

Data validation

Data validation must begin with

Excel formula: Data validation must contain specific text

Data validation

Data validation must contain specific text

Excel formula: Data validation allow uppercase only

Data validation

Data validation allow uppercase only

Excel formula: Data validation allow weekday only

Data validation

Data validation allow weekday only

Excel formula: Data validation date in specific year

Data validation

Data validation date in specific year

Excel formula: Data validation date in next 30 days

Data validation

Data validation date in next 30 days

Excel formula: Data validation require unique number

Data validation

Data validation require unique number

Excel formula: Data validation only dates between

Data validation

Data validation only dates between

Excel formula: Data validation allow text only

Data validation

Data validation allow text only

Excel formula: Data validation allow numbers only

Data validation

Data validation allow numbers only

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

Finally. Someone helping me see how to use Excel the way I want! I'm a long time C programmer, now learning Excel to create some medium complex budget planning for a non-profit organization. While I'm making progress beginning to "think Excel", your tutorials on complex references using INDIRECT are wonderful! The syntax makes my eyes water, but I see what they're doing and how I can use 'em. Aha! Thanks tons for helping me bridge the gap between how I think and Excel's tools.

Deborah

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Charts video training course

Video training for Excel Tables

Dynamic Array Formulas