Data validation is very important as it prevents bad data entry and thus saves time in data cleaning. Let us see how to prevent duplicates in data entry.
There 4 steps to building a good data validation:
- Test your validation formula first
- Select the area to apply the validation
- Create the validation Using your formulas
- Frequently Turn On the “Circle Invalid Data”
Bonus Data Validation:
How to ensure only valid emails are entered
Use this formula to test for valid email =ISNUMBER(FIND(“@”,C3))
- FIND Function checks if there is the @ character in the cell and returns a number else an error
- ISNUMBER Function checks if FIND has returned a number and returns TRUE else FALSE
How to ensure entered data has no spaces in excel
Use this formula =D3=SUBSTITUTE(D3,” “,””)
- SUBSTITUTE Function replaces all spaces in the string with nothing
Recent Comments