How To Create Searchable Drop Down List In Excel || Hindi || HD

Рет қаралды 491,447

6 жыл бұрын

#excel #excelmagictrick #searchabledropdown for Multiple cells is here • How To Create Searchab... 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 • How To Create Searchab...
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:
drive.google.com/open?id=1dhI...
vlookup in excel with example in Hindi
• Vlookup in Excel With ...
How to use IFERROR formula in excel || HINDI
• How to use IFERROR for...
Countif formula in excel
• COUNTIF formula in exc...
If formula in excel
• IF Logical Function in...
This a an amazing trick so go ahead and create a searchable dropdownlist in excel
Data Validation Part 1: • Data Validation in Exc...
* 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: • How to Create Drop Dow...
* 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: • Data Validation In Exc...
* 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 : • Custom Data Validation...
* 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 : • Excel में Duplicate En...
* Prevent Duplicate Entries In Column
* Allow Only Unique Entries - Avoid duplicate entries in excel using
Data Validation Part 6: • Data Validation Auto U...
* Auto Updating Dropdown List In Excel Hindi
Data Validation Part 7: • How To Create Dependen...
* How To Create Data Validation Dependent Drop Down List In Excel
Data Validation Part 8: • EXCEL - ये विडियो 😮 जर...
* EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number
Data Validation Part 9:https: • Custom Data Validation...
* Custom Data Validation- To Allow only Uppercase Text Entries In Excel
Data Validation Part 10:https: • How To Create Searcha...
* How To Create Searchable Drop Down List In Excel || Hindi || HD
Data Validation Part 11:https: • How to Create Drop Dow...
* how to create drop down list from another sheet in excel
Data Validation Part 12: • Data Validation Auto U...
* Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List
Data Validation Part 13: • EXCEL में Data Entry क...
* 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 देखे: goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: goo.gl/bbHYu2
MS WORD के लिए ये playlist देखे: goo.gl/B4TeSA
HTML5 & CSS3 के लिए ये playlist देखे: goo.gl/2PFgs8
COMPUTER के TECHNICAL videos के लिए ये playlist देखे: goo.gl/paZmpn
Subscribe to my channel: / deepakeduworld
Like my Facebook page: / deepakeduworld
Follow on LinkedIn: / 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,

Пікірлер: 755

@DeepakEduWorld 5 жыл бұрын

*To make this searchable dropdown in multiple cells or multiple sheets watch this 2nd video* kzfaq.info/get/bejne/mM2deMp33tW5g3U.html

@DeepakEduWorld 4 жыл бұрын

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

@aggarwal4943 5 жыл бұрын

This is Amazing ... liked it very much.. thank you for explaining it so simply

@DigiRuns 5 жыл бұрын

Oh my god, sir, u r a great Faculty in teaching and researching. Thanks for this wonderful tutorial.

@prakashmayyak9916 6 жыл бұрын

Super explanation. I have watched some other videos in which they give some formula to acheive some desired output. But, you explained each and every step for selecting a formula. All the very best. Thank you once again.

@akhileshkumar-xp3eh 2 жыл бұрын

Very Interesting Sir I have watched full video without skip Thankyou So much Sir..........

@aryan123raj 3 жыл бұрын

very Nice....Excellent Deepak

@murtazaeranpurwala3378 6 жыл бұрын

Very well explained sir!!! Thank you for all the help

@johnsonkv7734 4 жыл бұрын

REALLY GOOD AND IT IS ;HELPFUL

@sachincharde2883 2 жыл бұрын

Ur great sir thank u so much

@kevinseeam4849 3 жыл бұрын

from all the videos i've watched thats the only one that worked like a charm

@vinaygaur8605 6 жыл бұрын

I know it is lengthy but very innovative ..... thanks for such beautiful information

@keshavnayak1525 6 жыл бұрын

Thank U soo much for this type of unique and useful veido .

@ashiqmir2717 3 жыл бұрын

No words to describe it.... Simply Awesome....

@rajkumargupta2856 Жыл бұрын

Super explanation sir 👌👌 I had many problems in enable searchable drop-down in Excel but after watching this video I have any problem now. 🙏🙏Very very thanks sir 🙏🙏

@DILIPKISAN 6 жыл бұрын

The way u describe, I never get bored

@sikandarbhojani23 6 жыл бұрын

Very good explanation. Best of luck. You are really running very good channel.

@suhb6387 Жыл бұрын

Sir, Deepak your master of excel

@dnyandeosomawanshi9271 6 жыл бұрын

Thanks for knowledge sharing and that too with such simplicity. Great & really worth sharing to others.

@nahednaddu2971 5 жыл бұрын

Very Nice Explanation Concept fully understand

@gyanforyou7796 3 жыл бұрын

Thanks sir itta acha batane ke liye

@manasbhattacharjee Жыл бұрын

Nice & easy way to elaborate step by step formula. Thank You

@TheLibraannu 6 жыл бұрын

Thank you so much sir, me bahut tym se ye seekhna chah raha tha, u r amazing...

@indianmonster1445 5 жыл бұрын

Best For ever...................... One Query : - how to highlight particuler cell via drop downlist " Condition :- 50 Document names in my list , highlight list via Country name & Party name , using Dropdown list.........

@ranganathprahlad 6 жыл бұрын

You are a good teacher. Thank you very much.

@EasyDTH 4 жыл бұрын

Very intelligent bro..

@akashkelkar1128 5 жыл бұрын

aap to excel ke guru ho sir thank you

@dillooshariff2452 6 жыл бұрын

Great video and clear explanation. Thank you very much.

@munmunkumar2117 Жыл бұрын

Your Video is very helpful us. thank for make this type video sir

@SunilSingh-ee4sc 5 жыл бұрын

Impressed .... Mind-blowing idea thanks

@mewaramtoliya53 4 жыл бұрын

Sir yous all the excel vedio is most usfull for me so i can not dislike its, I like the excel from deepak eduword education, mari comment se aapko khed lga, I am sorriy

@ashutoshkalamkar 5 жыл бұрын

You are awesome boss. Thanks a lot for such video.

@dearloop1513 2 жыл бұрын

I was looking for this video and found this amazing. It is like a champion.

@BakhtiarAUqaili 3 жыл бұрын

Very good formula and excellent way to teach us

@rajendrabendre6635 3 жыл бұрын

Superb video sir ✨✔️

@sg-gaming6206 4 жыл бұрын

Bth achy say guide kia ap nay ik hi bar mai sab achy say pata lag jata hai

@sarbchd9898 6 жыл бұрын

sir kya baat h m tu apka fan ho gya Great job

@KhurrumIqbal1 5 жыл бұрын

Apka bataney ka andaz superb hai!

@rashidkhan4455 5 жыл бұрын

Thanks for sharing sir, Got some meaningful tricks ,

@samirawati1975 4 жыл бұрын

sir ji aapp gr8 ho.... thank you very very very very much...... pranam aapko

@shakilahmad7244 6 жыл бұрын

Excellent h sir Aur bahut hi usefull bhi h

@dhananjaykumar-oj6xe 5 жыл бұрын

this must be necessary question for school practical... awesome sir awesome... really

@officialpradeepjaat9761 Жыл бұрын

Super explain 🥰🥰🥰🙏🏻👌🏻

@harshadvegda8097 3 жыл бұрын

Deepak Sir, Excellent Formula Developed. This may not be in the minds of MS Office !!!

@syedelyas7090 5 жыл бұрын

Hai Deepak.. Precisely explained ty so much

@DeepakEduWorld 5 жыл бұрын

☺️

@pythusiast4701 3 жыл бұрын

Awesome deepak... this video is very helpful.. you are really a teacher. Hats off

@mdfazar2091 5 жыл бұрын

Fantastic sir... Thanks a lot

@dkthetechiboy6505 3 жыл бұрын

Best sir i love it.

@kanhucharanadas3948 4 жыл бұрын

Jabardast Dipak sir

@DeepakEduWorld 4 жыл бұрын

😊😊😊

@kishupatel2839 2 жыл бұрын

Excellent sirji.. it is too much useful for me.

@harkaransingh1190 3 жыл бұрын

Sir i am from punjab i learned a lot of things from you

@AftabAlam-vg6tm 5 жыл бұрын

Very beneficial for us. Thanks a lot.

@shashikantha1803 3 жыл бұрын

Superb, thanks for sharing and guiding

@ismailjanab9653 3 жыл бұрын

Thank you for this video. it will help me a lot. easily explained

@archanamuppidi14 6 жыл бұрын

Wow... ur doing sooo much of help... thank u for sharing.... very good explanation and presentation... great job...

@ashunpj 5 жыл бұрын

Thanks for sharing your knowledge.

@poonamdhiman5140 6 жыл бұрын

Sir aap ki excel knowlege incredible h. Aap language formulas excel me bahut ache se implement karte h.

@DeepakEduWorld 6 жыл бұрын

Poonam Dhiman thanks

@SHADABKHAN-lq6zj 4 жыл бұрын

Sir aapki video bht achi होती है Sir मुझे ये janna tha mera jewellery box का काम he तो अलग अलग साइज़ होते ही और design भी टैक्स सबका ak होता ह to मे उनके design के saath rt भी और cod भी aa जाए gst bill me

@rakeshsahani336 5 жыл бұрын

Apne to excel per phd kar rakhi hai Thanks...

@nitishkumarmishra4903 5 жыл бұрын

kya kamal ki samjhate hain aap sir

@AsadShaheenAkram 5 жыл бұрын

Difficult but Very Useful :)

@SuperKASHIF87 6 жыл бұрын

zabardast 👌🏻

@mithukhalifa7460 4 жыл бұрын

Your video very smart and clear . Thanks for making this video

@FutureComputerInstitute 6 жыл бұрын

Well and good

@naveedahmedvt3613 3 жыл бұрын

THANKS...EASILY UNDERSTOOD

@awladhossain210 4 жыл бұрын

Thank you so much. it helped me so much

@smb52 6 жыл бұрын

Thanks!! This is ultimate!! Salute to you!!

@TVSCDN Жыл бұрын

Thanks a million 🙏❤️👍🎉😍

@uday1607 3 жыл бұрын

Superb sir, Simply fantastic. All the best. Your videos are MUST for every learner.

@mrmrimran1 6 жыл бұрын

very good channel, plz also make video for making database of daily use excel file.

@DeepakEduWorld 6 жыл бұрын

+mrmrimran1 ok

@luhif110 3 жыл бұрын

Very Good Explanation Keep up good work

@subratapanda9195 Жыл бұрын

Thank you sir jee

@yuva3444 6 жыл бұрын

Really very useful & explanation.

@sandeepgusain2154 4 жыл бұрын

bhut badiya tha.

@goutamkarmoker4602 2 жыл бұрын

Nice teacher

@fahimkhan357 6 жыл бұрын

Very nice explain thank you so much

@jaslokjha1410 7 ай бұрын

Thanks Deepak bhai❤

@infocare2210 4 жыл бұрын

THANK YOU SIR

@santoshsawant4204 2 жыл бұрын

Great work. 🙏🏻🙏🏻🙏🏻

@mwxfl45h33 9 ай бұрын

Great work sir.. we need this trick even after 5years..

@mr.a_a9407 3 жыл бұрын

Awesome .. thank you

@ConsulthinkProgrammer 3 жыл бұрын

Try this to bring search in google sheets to the next level with keywords name and birth date kzfaq.info/get/bejne/jrWqhaao3qnPlHU.html

@starblack9419 3 жыл бұрын

Thank you so much

@banwarifageriaexcelclasses1447 4 жыл бұрын

ITS WONDERFUL ..THANKS

@DeepakEduWorld 4 жыл бұрын

😊😊

@gycomputertech 5 жыл бұрын

super sir nice expen in topic

@imranomar207 3 жыл бұрын

A very knowledgeable video for excel lover . keep it up

@HumanistLogic 2 жыл бұрын

Thanks bhai... you are awesome

@prabhakarpawar573 5 жыл бұрын

Nice and very usefull video sirji

@rajendrajomajipatil8314 2 жыл бұрын

Thanks a lot Sir for this video

@JJ-gi8nx Жыл бұрын

zberdust bless you

@FutureComputerInstitute 6 жыл бұрын

2nd time see this video... log step but good.

@DeepakEduWorld 6 жыл бұрын

+Hindi जगत 👍👍

@worldexpress9186 5 жыл бұрын

sir aap bohat acha kaam kertay ho thanks

@srsandeepsinghnegi 6 жыл бұрын

very nice video.

@85pawanpau 6 жыл бұрын

Thanku Sir Nice Video

@rastogi2006love 4 жыл бұрын

Bahut badhiya :)

@birendraprasadsah5517 6 жыл бұрын

Nice video!

@javed4sm 4 жыл бұрын

very good friend and thanks for your efforts to learn us

@jahangirsachwani8553 4 жыл бұрын

Beautifully explained 👍

@DeepakEduWorld 4 жыл бұрын

😊

@khalidalisubhanallah2947 6 жыл бұрын

LENGTHILY HA PAR ZABAR DAST MAZA AGAYA.

@apshukla9 2 жыл бұрын

Awesome.. salute for your hard work keep it up 👍

@lahotanu 6 жыл бұрын

SIR BAHUT HI BADIYA

@09shirish 6 жыл бұрын

Very Nick, Thanks !!