All resources related to DATA VALIDATION for Excel and Google Sheets.

Learn What Data Validation Must Begin with in Excel

Data validation is a powerful feature in Excel. We can use it to control how a string begins with. Using the EXACT and LEFT function with data validation, we can control how a value begins with. In this tutorial, we will learn how to validate the start of a value...

Excel DATA VALIDATION using SUM Function

Figure 1. Excel DATA VALIDATION using SUM Function. If we decide to restrict users to only input numeric values whose totally or sum does not exceed a specific amount within a selected range of cells, then we can achieve this by using a custom Data Validation formula. Formula Syntax =SUM($C$2:$C$9)<=50000...

Excel DATA VALIDATION Using the TODAY and AND Functions

Figure 1. Excel DATA VALIDATION Using the TODAY and AND Functions. Let's assume that we have to generate a DATA VALIDATION using Excel's TODAY and AND Functions to permit entries of dates occurring within the next 30 days, we must utilize a custom formula syntax based on the AND and...

Excel Data Validation Using the YEAR Function

Figure 1. Excel Data Validation Using the YEAR Function. Let's assume that we have to generate a DATA VALIDATION using Excel YEAR Function to permit entries of dates occurring within a specific year, we must utilize a custom formula syntax based on the YEAR Function in Excel. Formula Syntax =YEAR(date)...

Excel Data Validation Istext Function

Figure 1. Excel Data Validation Istext Function. If we want to permit text entries only in the cells of our Excel sheet, we are going to utilize data validation with a custom formula derived from the ISTEXT function Formula Syntax =ISTEXT(A1) This formula is useful for restricting users from populating...

Excel DATA VALIDATION Using the ISNUMBER and FIND Function

Figure 1. Excel DATA VALIDATION Using the ISNUMBER and FIND Function. If we want to permit entry of data values containing a specified text string only, we are going to make use of a custom data validation formula derived from the FIND and ISNUMBER functions in Excel. Formula Syntax =ISNUMBER(FIND("txt",A1))...

Excel Data Validation Using the WEEKDAY Function

Figure 1. Excel Data Validation Using the WEEKDAY Function. We can utilize a custom data validation formula derived from the Excel WEEKDAY function, if we want to permit a user to enter only dates that occur during the week (Monday - Friday). Formula Syntax =WEEKDAY(A1,2)<6 This formula will return any...

Excel DATA VALIDATION Using ISTEXT, UPPER, EXACT and AND Function

If you want to learn how to use DATA VALIDATION to allow only uppercase text in Excel, you will have to use the combination of several functions AND, EXACT, UPPER and ISTEXT. DATA VALIDATION. These allow you to validate fields that are entered and changed by certain criteria. Allow uppercase...

How to Use the DATA VALIDATION ISNUMBER Function in Excel

You can create your own data validation to allow numbers only in Excel. To do this, you need to use the ISNUMBER function. In this tutorial, you will learn how to create a data validation to allow only allow numbers using the ISNUMBER function. Use data validation in Excel to...