Excel Data Validation: List, Date, Time, Custom (22 Examples)

Topics: Data Validation, Text Formulas, Date Formulas, Flash Fill and Array Formulas

Topics in this video:
1. Data Validation to allow only whole numbers between an upper and lower limit (00:27 min)
2. Create an Input Message for your Data Validation (02:00 min)
3. Error Message with “Stop” (02:18)
4. Circle Invalid Data (03:00 min)
5. Copy and Paste To Wreck Data Validation (03:58 min)
6. Data Validation to allow only decimal numbers below or equal to an upper limit (04:32 min)
7. Error Message with “Warning” (04:56 min)
8. Error Message with “Information” (06:12 min)
9. Data Validation drop down list using a range of cells (07:44 min)
10. Data Validation drop down list using a Defined Name (08:32 min)
11. Ctrl + Shift + F3 = Create Names From Selection for a single column (08:36 min)
12. Data Validation drop down list using a Dynamic Table Name (09:14 min)
13. INDIRECT Function trick for Table Name (10:56)
INDIRECT function takes text that represents a reference and converts it back to a reference.
14. Data Validation List when you type text in source dialog box (13:24 min)
15. Create a Dependent Data Validation List based on a second Data Validation Dropdown List (13:57 min)
16. Ctrl + Shift + F3 = Create Names From Selection for a multiple columns column (14:50 min)
17. INDIRECT Function trick for Dependent Data Validation: to take text that represents a reference and convert it to a reference (16:13)
18. Data Validation to allow only dates between an upper and lower limit (17:06 min)
19. Data Validation to allow only times above or equal to a lower limit (18:04 min)
20. Data Validation to allow a certain text length (18:46 min)
21. Custom Data Validation Logical Formula to allow only prices that are less than or equal to double the cost (19:18 min)
22. Custom Data Validation Logical Formula to prevent duplicates (20:57 min)
23. Summary Comments (23:49 min)
Data Validation List