Formula Related Functions
Data validation allow numbers only ISNUMBER
Data validation allow text only ISTEXT
Data validation allow uppercase only UPPER EXACT AND
Data validation allow weekday only YEAR TODAY
Data validation date in next 30 days AND TODAY
Data validation date in specific year YEAR TODAY
Data validation don't exceed total SUM
Data validation exists in list COUNTIF
Data validation must begin with EXACT LEFT COUNTIF
Data validation must contain specific text FIND ISNUMBER
Data validation must not contain ISNUMBER SEARCH SUMPRODUCT
Data validation must not exist in list COUNTIF
Data validation no punctuation FIND COUNT
Data validation only dates between AND DATE
Data validation require specific multiple MOD
Data validation require unique number AND ISNUMBER COUNTIF
Data validation specific characters only MATCH COUNT LEN MID INDIRECT
Data validation unique values only COUNTIF
Data validation whole percentage only TRUNC AND
Data validation with conditional list IF