How To Create Searchable Drop Down In Excel || Easy Steps || Hindi

Рет қаралды 140,465

5 жыл бұрын

How To Create Searchable Drop Down In Excel कमाल की Dropdown list एक्सेल में बनाये जो multiple cells में भी काम करेगी और multiple sheets में भी और Dynamically update automatic होती रहेगी 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 in multiple cells multiple sheets and dynamically auto updated.
#searchabledropdown
#excel
#deepakeduworld
#exceltutorial
Download Training File : drive.google.com/open?id=1IzN...
Searchable list 1st video link : • How To Create Searcha...
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
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 -
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
Data Validation Part 13: • EXCEL में Data Entry क...
दोस्तों आपके Likes एंड Comments मेरे को Motivate करते हैं Batter और Useful वीडियोस बनाने के लिए। इसलिए प्लीज वीडियो को Like जरूर करे और वीडियो आपको कैसा लगा कमेंट में जरूर लिखो। अगर आपका कोई सुघाव है तो वो भी आप मुघे कमेंट में जरूर लिखो... Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_______________________________________
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
Tags: Internet,Computer user,Technology hindi, Learn Computer hindi,computer experts, excel user, deepak eduworld,computer tips,, excel tricks,tips,

Пікірлер: 318

@DeepakEduWorld 5 жыл бұрын

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

@imthusan 4 жыл бұрын

thanks deepak,bahooth badiya bhai

@suryapakhrin9769 3 жыл бұрын

After saved it ... the drop down list are not completely shown

@farhadacca7314 3 жыл бұрын

Dear Mr @Deepak , can you whatsapp me at 00971554876057 please

@PharmacistRazique121 3 жыл бұрын

Sab kaam thik se hogaya.aur save bhi kiye the file ko..lekin jab dobara file open kiye to sab khatam hogaya...

@PharmacistRazique121 3 жыл бұрын

@@suryapakhrin9769 same problem i faced

@manojindrasan95 2 жыл бұрын

Really this video is very very helpful. Thanks a lot

@kvrwebservices9330 2 жыл бұрын

Thank you very much sir. Very very useful video to me.

@chetanchauhan_baba Жыл бұрын

Very very very good video...👌👌👌

@singhkulpreet95 2 жыл бұрын

Really helpful video. Thank you sir

@jnbaluch 2 жыл бұрын

Great sir..... very help full... you solved my problems ... God Bless you.....

@RahulKumar-ly6ly 3 жыл бұрын

Thanks sir very helpful video happy holi sir

@NewVoice5 2 жыл бұрын

Ap to guru ho sir❤️

@santoshkumarpant219 9 ай бұрын

it is very helpful. thank you so much.

@mithileshkumarsharma1807 5 жыл бұрын

Abhi tak ka sabase sansar video thanks sir

@Test_yourknowledge 4 жыл бұрын

Very useful video 👌👌👍

@suryamanikumar123 Жыл бұрын

Very Very Thank You So Much.... for prepare this type of knowledgeble videos....

@msaralihubli7648 3 жыл бұрын

sir, it is very use full me thanks sir.

@rahulgoenka4570 Жыл бұрын

Very well explained. I followed the video to the T and it really worked. Thanks

@gladsonjeremias4598 2 жыл бұрын

Bohut badhiya dost. Mera dheer saara pyaar.

@srikanthgali8991 Жыл бұрын

U are my hero.

@SanjaySolanki-lx4sy 3 жыл бұрын

Sir mera naam sanjay solanki hai mene apke videos dekhkar excel me bahut kuch sikha hai...

@kevalshirode7797 3 жыл бұрын

Thank you It is helping alot

@splendid1963 3 ай бұрын

👍great video. Your explanation is very nice

@sherwaliafridi1890 2 жыл бұрын

You Are Toooooo Good Yaar

@ibraheemmshezad400 5 жыл бұрын

BOHAT GREAT SIR ITS A AMAZING AND MAJICAL VIDEO SB KA SB CONCEPT CLEAR HO JATY HAIN AP KI VIDEO SA

@nurmohammed6355 2 жыл бұрын

thanks, dear this trick., a very complicated, huge formula in one video.

@kvrwebservices9330 2 жыл бұрын

Sir, very very useful video for me. Thanks a lot.

@doojramyadav1450 4 жыл бұрын

हेलो सर आपके समझाने का तरीका इतना प्यारा और सरल है कि कोई भी इंसान को तुरंत समझ मे आ जाता है आपने जो आज Searchable Drop Down फोर्मुला के बारे मे बताये है वह मेरे लिये बहुत ही काम का है इसके लिये मै आपको बहुत बहुत धन्यावाद देना चाहुंगा !

@bipinkumaryadav5411 5 жыл бұрын

आपके सभी वीडियो लाजवाब होते हैं, बहुत अच्छी तरह से समझाते हैं। बहुत बहुत धन्यवाद 🙏🙏🙏

@nidhitasaini5895 5 жыл бұрын

U r the best teacher on u tube

@adityavarma461 Жыл бұрын

Thanks guru ji

@user-fb1ru1dj2r 3 жыл бұрын

Very helpfulness.thank you so much Deepak ji.

@riazahmedmalik 5 жыл бұрын

God bless you Deepak sir, thanks a lot for prompt response on request. You are a wonderful teacher.

@rehan2520 2 жыл бұрын

Awesome... ma such ma is ko kal sy soch raha tha k searchable drop down list kesy bnaye

@pramodchandelpkc 4 жыл бұрын

Very Helpful tricks

@DeepakEduWorld 4 жыл бұрын

😊

@tarunuc Жыл бұрын

You are genius bro. Great learning

@VinayKumar-vs8jd 2 жыл бұрын

Very nice trick, it's very useful for preparing any MIS

@ChintanSuthar02 2 жыл бұрын

Really Helpful Brother.. Hats Off to your knowledge and easy explanation.

@raj95122 3 жыл бұрын

Sir aapko bahut bahut dhanyawad Is topic pr vedio banane ka Lekin sir isme ek or chij add krni hai Searchable ke sath multiple cell me multiple dependent list kese banaye please is topic pr bhi vedio banaye👌👌 Sir offset ka use krke jo name define kiya to use drop down list me indirect function ke sath kese use kare Please 🙏🙏

@amansuthar1923 3 жыл бұрын

Superb Thank you sooo much bohot kam kam ho gya iski wahaj se

@ravidattkumar6153 Жыл бұрын

जय हिन्द ये वीडियो मेरे लिए बहुत महत्वपूर्ण है क्योंकि मुझे रोज 200 supplier में से 20-50 नामों की लिस्ट बनानी पड़ती है. इसकी सहायता से मेरा काम बहुत आसान हो जायेगा आपका बहुत बहुत धन्य बाद 🙏

@sumitkumarbhandari6729 Жыл бұрын

Sir app genius ho...🙏🙏 What is Advance Excel? Advance Excel ke liye kon konsi topic jan na chahiye?

@rajeshshah6758 4 жыл бұрын

Hello Sir, Aaj Phir zaroorat pad gayi. Ek he baar mein samaj mein aa jata hai. Tussi Great Ho!!

@johnalfred93 Жыл бұрын

Hi Deepak Bro , I am a Medical Doctor but your excel videos were very very useful to me personally !!! Thank you brother!

@DeepakEduWorld Жыл бұрын

You r welcome doctor bhai 🤗

@jitendrabomble2218 3 жыл бұрын

Thanks. Nice information. 👌👌👍👍🌹🌹

@animalworld2939 Жыл бұрын

Obviously very nice following your tutorials for more than two years . Thank you for your help and amazing tutorials.

@dnanokar27 4 жыл бұрын

वा मस्त। सही व्हिडीओ भाई। बहुत काम का व्हिडीओ।

@DeepakEduWorld 4 жыл бұрын

😊😊😊

@rajeshshah6758 4 жыл бұрын

Deepak Bhai, Aaj phir zaroorat padh gayi aapke is video ki. Kash mujhe aap ke jitna gyan hota toh ek bar mein aap ka video dekh ke aur bina dekhe main apni searchable drop down list bana paata. Thanks once again for the video.👍👍👍👍👍👍👍👍👍👍👍👍

@DeepakEduWorld 4 жыл бұрын

🥰🥰🥰

@KaileshHambireIJ-G- 5 жыл бұрын

Excellent video, i will try to make drop down for different GST RATES for tax invoice. I really wanted to learn this feature in excell, Thanks once again.

@mukeshsharma3948 3 жыл бұрын

Thank you so much sir

@sanjibkumar2627 3 жыл бұрын

This is really helpful for me... I was searching for this for long time & watched so many videos... & finally my finding is over.... Explained very well... Thank you so much

@md.shafiqulislam8121 Жыл бұрын

Thanks Dada, your video is very clear to understand. Many people is learning from those as needed

@srikantamandal4858 3 жыл бұрын

Very Helpful Video........

@rhmanagoli 3 жыл бұрын

Very useful

@vishalbhati912 3 жыл бұрын

Bahot khatarnaak complication

@sukher_chabikathi 5 жыл бұрын

Very useful video.. Thanks a lot.. U r awesome

@DeepakEduWorld 5 жыл бұрын

👍😊

@user-yz3tw7ig9j 2 жыл бұрын

Really OWSM ❣️ Video But Hard-work hai thoda Dhyan dena padega 🙆🏻‍♂️

@rajeshshah6758 4 жыл бұрын

Superb Deepak Bhai.

@muhammadfahad4552 2 жыл бұрын

Excellent bro. Exactly what i need, I going to use it in Driver Manifest excel to fill the form. Thanks bro

@digzworld7805 4 жыл бұрын

Salute hai bhai apko..

@mohammedshameelv74 4 жыл бұрын

Thank you very much for this valuable knowledge

@Technical3Idiots 5 жыл бұрын

Wow...... Really this means!!! 🔥 🔥 🔥 🔥

@islamkhan4142 4 жыл бұрын

Verry thanks full off you bro

@GopiNath-fp5ly 5 жыл бұрын

Super video with lots of hard work.

@maheshagnihotri1333 5 жыл бұрын

Deepak sirji, best in the world

@javed4sm 4 жыл бұрын

you are great

@syedansarab3941 4 жыл бұрын

THANK VERY MUCH FOR YOUR MOST VALUABLE INFORMATION

@nikhilkukde6704 5 жыл бұрын

Excel master ❤️❤️❤️❤️❤️

@JaspreetSingh-jp5qc 3 жыл бұрын

Great job bro, i really appreciate your work👍👍👍👍

@myhelpdesk6414 5 жыл бұрын

Sir you are great, awesome.. Nice video thanks sir...

@abdulhamidalhaddadi2255 Жыл бұрын

Great Deepak

@MANOHARLAL-BHADU 5 жыл бұрын

Very good

@tarungargtkg 4 жыл бұрын

Thanku for sharing valuable this ngs

@karankumar-sx2mw 4 жыл бұрын

Ase video pe 1 like to banta hai👌

@spaceajay 3 жыл бұрын

Awesome that's what I was looking for thanks a ton

@jigar7755 4 жыл бұрын

Bahut sahi hai. Aapki list me kuch log real in item hai.

@DeepakEduWorld 4 жыл бұрын

😊

@empoweringnet2415 3 жыл бұрын

I was looking for it for a long time, now i got it and it's quite good and use full for me, thanks

@kabirsahib1552 3 жыл бұрын

It's very lengthy formulas and process. There is an easy way to do it. Just single cell formulas.

@salaidhiraviyam8561 Жыл бұрын

Very useful. Thanks

@vinodpareek8023 Жыл бұрын

Hi Deepak very nicely explained , I was looking such function for my purpose and got it after a big search, very useful will try to creat data enry for our use Thanks a lot Jai Hind

@umairzahid3743 3 жыл бұрын

beautiful sir zabardast.

@stardipto 11 ай бұрын

thnks fr sharing,but the whole process is tough enough

@laxmikanth3395 4 жыл бұрын

this is 200% work on Multiple inventory find for me thanks

@DeepakEduWorld 4 жыл бұрын

🤗😊

@sherazrathoor8552 5 жыл бұрын

Outclass video bhai eid mubarak

@pradeepy009 4 жыл бұрын

Thank you so much it really helped

@prashant1513 4 жыл бұрын

Thanks Deepak Sir

@nilaykalol 5 жыл бұрын

Very Very Useful

@mddelowarhossain1371 2 жыл бұрын

You are an excellent teacher

@moynulmiah7291 2 жыл бұрын

Thanks boss I am from Bangladesh

@soumenray1836 5 жыл бұрын

Fantastic......

@DeepakEduWorld 5 жыл бұрын

☺️

@krishnendubikashmajumder8898 5 жыл бұрын

Seriously Boss thank you so much.

@khanaziz66 4 жыл бұрын

Really.

@abhishakya5263 3 жыл бұрын

Good video

@188ahmed188 3 жыл бұрын

Well done 👏

@vijaydubey2009 5 жыл бұрын

1st of all thank a ton for your helpful videos. It is really a great act of Kindness towards working class. Further, I have a question in my mind that what will be the over all impact of that VBA code in a particular sheet? Please elucidate. Thanks again.

@shivamdwivedi2492 5 жыл бұрын

Dear sirI first watch and like and share this video

@071538 4 жыл бұрын

Great

@MANOHARLAL-BHADU 5 жыл бұрын

बहुत अच्छा

@shyamsundarinfotech6449 3 жыл бұрын

FABULOUS VIDEOS, I USE THIS WITH GST INVOICE BILL. ITS WORK GREAT. PLEASE MAKE A VIDEO FOR PURCHASE BILL ENTRY WITH ITEM AND LEDGER MAINTAIN.

@DeepakEduWorld 3 жыл бұрын

🤗 asap 👍

@khanaziz66 4 жыл бұрын

U R great. Thanks dear.

@DeepakEduWorld 4 жыл бұрын

😊

@SumantaSaha27 3 жыл бұрын

Sir, bohot helpful hota h apka video, long time se follow karta hu me. but Ek waisa video banaye please... jo Auto updatable searchable invoice, Jaha Products price, hsn code, rehega. aur wo bat me mobile excel me eassyly access kar sake....please sir...please please....kripa kar k banaye to bohot help hoga...

@DeepakEduWorld 3 жыл бұрын

ASAP i ll publish video

@SumantaSaha27 3 жыл бұрын

@@DeepakEduWorld kya bataye sir samjhe nehi...pls

@krishanchauhan6679 3 жыл бұрын

Thank you so much

@naushad123 Жыл бұрын

it worked

@9928960170 5 жыл бұрын

Very nice sir ji

@salimudaipurwala1579 3 жыл бұрын

God bless for sharing your knowledge with us. Only one problem, when we use view code and write "application.calculate" than in that worksheets cell cannot move left right up down with arrow key. Only worksheets move and cursor move with tap key from left to right. Any solution for that?

@laxmikanth3395 4 жыл бұрын

very helpful for inventory control

@DeepakEduWorld 4 жыл бұрын

🤗😊