Summary
Keywords
Full Transcript
#excel #excelmagictrick #searchabledropdown for Multiple cells is here https://youtu.be/bgmEgFyoUSA Learn how to search data validation drop-down lists in Excel Hindi. In this Excel tutorial you will learn fantastic trick to make a searchable dropdown list with #autosuggest feature in Excel 2007 2010 2013 2016. To create this searchable list in multiple cells and sheets see this video https://youtu.be/bgmEgFyoUSA Formulas used to create this dropdown list are: 1 search Formula 2 Isnumber Formula 3 If Formula 4 max Formula 5 rows Formula 6 vlookup Formula 7 iferror Formula 8 offset Formula 9 Countif Formula Download Training file: https://drive.google.com/open?id=1dhIUwzFA1eHeFaP7Qoio4Noik5__rDRs vlookup in excel with example in Hindi https://youtu.be/S2rF6bHIbdA How to use IFERROR formula in excel || HINDI https://youtu.be/TF_JAqcPA5w Countif formula in excel https://youtu.be/HgFHx17PPcc If formula in excel https://youtu.be/l2RjYPd-CIo This a an amazing trick so go ahead and create a searchable dropdownlist in excel 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 Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo * Auto Updating Dropdown List In Excel Hindi Data Validation Part 7:https://youtu.be/Ig245IO7lPs * How To Create Data Validation Dependent Drop Down List In Excel 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 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/deepakeduworld *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA *********************************************************** Tags: कंप्यूटर, दीपक ऐडवर्ल्ड, एक्सेल,Internet,Computer user,,Learn Computer hindi, ms office,ms excel,word, excel course, hindi technology, deepak eduworld,computer tips, shortcut keys, excel tricks,tips,
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
