Скачать или смотреть 008. Advanced Custom Data VALIDATION using FORMULAS

This is the second part of the data validation lesson where you will learn how to do custom validation rules using formulas. We will look at 3 examples to learn:
1. How to define rules with formulas
2. How to combine formulas into 1 rule
3. Where to paste the rule

For this we will use multiple example formulas. Here are some links:
Data Validation Basics:    • 007. Use Data Validation to Create SMART D...  
LEFT/RIGHT:    • 045. Pick up characters from a cell using ...  
MID:    • 047. Handpick characters from a Text using...  
LEN:    • 048. Measuring the number of characters in...  
MID + LEN:    • 049.Want to select part of a cell but the ...  
AND:    • 013.The ins and outs of the AND formula! i...  
OR:    • 014.The ins and outs of the OR formula! in...  
NOT:    • 015.The Not formula - Often underused. Lea...  
Isnumber:    • 030. Check if your data is a number with I...  

Content: advanced custom data validation using formulas, advanced custom data validation, data validation using formula, check for text in data validation, data validation with text and numbers, custom formula for data validation in excel, excel data validation list and custom formula, how to use formula in data validation, can you use formulas in data validation, advanced data validation tricks in excel, trips and tricks for data validation in excel, data validation basics, microsoft excel


#Excel #MsExcel #DataValidation