Excel Custom Data Validation

How to Use Custom VLOOKUP Formula in Excel Data Validation

Data Validation in Excel gives you the facilities to set a validation range of data that can help you in many ways like which data you can select or ...

How to Use IF Statement in Data Validation Formula in Excel (6 Ways)

Here, we have some records of some of the products and their corresponding salesperson’s names of a company. By using this dataset, we will ...

Apply Custom Data Validation for Multiple Criteria in Excel (4 Examples)

Sometimes we need to input data based on multiple criteria in our Excel datasheet. Data entries that don’t follow our desired conditions may create ...

How to Perform Data Validation for Alphanumeric Only in Excel

Alphanumeric characters are a mix of alphabetical and numerical characters. There are 36 (A-Z and 0-9; case insensitive) or 62 (A-Z, a-z and 0-9; ...

Data Validation Based on Another Cell in Excel (4 Examples)

How to Do Data Validation in Excel? Take a dataset that includes student ID, student name, and age. We would like to make a data validation where ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo