Excel custom Data Validation [ Hindi ] - Prevent Duplicate Entries In Column | Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation. Allow only unique values in columns / rows. Advanced Data Validation
and i explained the complete data validation option in parts with best explanation [ ms excel 2007/2010/2013/2016 ]... links is given below....
____________________________________________
How to use countif formula : https://youtu.be/HgFHx17PPcc
____________________________________________
Data Validation Part 1: https://youtu.be/U3XdCUmNaBg
* 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 Part 2: https://youtu.be/-IDqfwby5MM
* 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 Part 3: https://youtu.be/VjVpMVO8Jq0
* 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
____________________________________________
Data Validation Part 4 : https://youtu.be/ZTlymO0uug4
* 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
____________________________________________
Data Validation Part 5 : https://youtu.be/vzeWlggal88
* Prevent Duplicate Entries In Column
* Allow Only Unique Entries - Avoid duplicate entries in excel using
custom data validation.
____________________________________________
Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo
Auto Updating DropDown List In Excel Hindi ||
Dynamic DropDown List
____________________________________________
Data Validation Part 7: https://youtu.be/Ig245IO7lPs
How To Create Data Validation Dependent Drop Down List In Excel || Best
Video || Hindi || HD
____________________________________________
Data Validation Part 8: https://youtu.be/tn4ShvcvBls
EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text
/Number
____________________________________________
Data Validation Part 9:https: https://youtu.be/WULhnIsKguU
Custom Data Validation- To Allow only Uppercase Text Entries In Excel
____________________________________________
Data Validation Part 10:https: https://youtu.be/HwVbH_x6nMk
How To Create Searchable Drop Down List In Excel || Hindi || HD
____________________________________________
Data Validation Part 11:https: https://youtu.be/-IDqfwby5MM
how to create drop down list from another sheet in excel || Hindi | using
data validation
____________________________________________
Data Validation Part 12: https://youtu.be/EX2ZahZ3pHo
Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic
DropDown List
____________________________________________
Data Validation Part 13: https://youtu.be/e6R4zZdlxHY
EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2
MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA
HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8
COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn
---------------------------------------------------------------------------
----------------------
---------------------------------------------------------------------------
----------------------
Subscribe to my channel: https://www.youtube.com/deepakeduworld
Like my Facebook page: https://www.facebook.com/deepakeduworld
Follow on LinkedIn: https://www.linkedin.com/in/deepakedu...
Facebook Group : https://www.facebook.com/groups/cse92/
***********************************************************
Thanks for Watching
Happy Learning
DEEPAK NEHRA
***********************************************************
Excel में Duplicate Entries से ऐसे बचे - Prevent Duplicate Entries in Excel HINDI conditional meaning | |
| 716 Likes | 716 Dislikes |
| 31,124 views views | 290K followers |
| Education | Upload TimePublished on 21 Dec 2017 |
Không có nhận xét nào:
Đăng nhận xét