Data Validation in Excel [ Hindi ] - Best Ever Explanation PART -1 by Priyanshu gautam

Описание: data validation in excel - Learn how to use Data Validation tools in Excel 2007 2010 2013 2016 Hindi to improve the accuracy of the data in your spreadsheets. ignore invalid data using data validation

Full detailed explanation for data validation

Data Validation to allow only whole numbers between an upper and lower limit
Data Validation to allow only decimal numbers below or equal to an upper limit
Create an Input Message for your Data Validation
Error alert Message with "Stop"
Error alert Message with "Warning"
Error alert Message with "Information"

____________________________________________
Data Validation drop down list using a range of cells
Data Validation drop down list using a Defined Name
Make data validation list from another worksheet in excel 2007

____________________________________________
Data Validation to allow only dates between an upper and lower limit
Data Validation to allow only times above or equal to a lower limit
Data Validation to allow a certain text length

____________________________________________
Allow only numbers in cell & Set limit of digits to accept.
Allow only text in cell & set character limit to accept.
Allow only 10 digit mobile number in cell

____________________________________________
Prevent Duplicate Entries In Column
Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation.

____________________________________________

Auto Updating DropDown List In Excel Hindi ||
Dynamic DropDown List

____________________________________________
Thanks for Watching
Happy Learning
DEEPAK NEHRA
***********************************************************