data validation
-
Automating Data Validation lists in Excel
-
Block duplicate entries in Excel table
-
Excel - Data Validation error checking & other useful tips
-
Excel Tables as source for data validation lists
-
Unique Data Validation drop-down from duplicate table data
-
Use Excel's Data Validation to display data entry tips for users
-
Using Data Validation to force a decimalized numeric entry
-
Validating an entry as a real date