Scribd
Upload
31 views8 pages

Data Validation Examples

The document contains examples of using Excel's data validation feature to restrict cell entries to meet certain criteria, such as only accepting text, values larger than the previous cell, non-duplicated data, dates that are Mondays, values under a set budget, and entries that begin with a specific letter and contain a certain number of characters. Ranges are also set up to only allow certain items to be selected from a list.

Uploaded by

Akash Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
31 views8 pages

Data Validation Examples

The document contains examples of using Excel's data validation feature to restrict cell entries to meet certain criteria, such as only accepting text, values larger than the previous cell, non-duplicated data, dates that are Mondays, values under a set budget, and entries that begin with a specific letter and contain a certain number of characters. Ranges are also set up to only allow certain items to be selected from a list.

Uploaded by

Akash Kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Excel Data Validation

Accept only text entries


100 Data Validation
132 Accept value only if it is larger than the previous cell
155
1 32 Data Validation
2 33 Accepts only non-duplicated data
3 34
4 35
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Alpha Data Validation
apple Accept entry only if it begins with A
Amos
Alpha Data Validation
apple Accept entry only if it begins with A and contains five characters
Aaron
Monday, May 25, 2015 Data Validation
Monday, January 04, 2016 Accept date entry only if it is a Monday.
Meat: $120 Data Validation
Vegetables: $25 Accept a value only if it doesn't go over the budget.
Fruit: $50
Snacks: $40
Alcohol: $200 Party Budget: $500
Soft Drinks: $50 Total: $485
Vegetables Fruits Meats
Arugula Apple Beef Fruits Apple
Asparagus Cherry Chicken
Beet Lemon Lamb
Broccoli Orange Pork
Carrot Peach
Cauliflower Pear
Celery Raspberry
Corn Strawberry
Green Bean
Onion
Potato
Radish
Squash
Turnip

You might also like