No video :(

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

Подписаться 1,2 млн

Просмотров 495 тыс.

50% 1

#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.c...
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,

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 760

@akhileshkumar-xp3eh 2 года назад

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

@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 🙏🙏

@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 5 лет назад

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

@sg-gaming6206 5 лет назад

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

@samirawati1975 4 года назад

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

@manasbhattacharjee Год назад

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

@kevinseeam4849 3 года назад

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

@KhurrumIqbal1 5 лет назад

Apka bataney ka andaz superb hai!

@sachincharde2883 3 года назад

Ur great sir thank u so much

@nitishkumarmishra4903 6 лет назад

kya kamal ki samjhate hain aap sir

@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.........

@shashankyadav5549 5 лет назад

Thank Your Sir Qki m 2 mnths se searchable drop down dekh rha tha different different youtube video k threw but finally aapki is video m step by step saare concept clear h is video k baad. Sir 1k q. h agr hme number format m Searchable drop down chaiye to uske liye kya SYMBOL hoga jaise Text ("?*") then Number = ?. please help me.... Thank You

@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

@vinaygaur8605 6 лет назад

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

@munmunkumar2117 Год назад

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

@jayeshshah5648 4 года назад

is it possible that if we type raj and it should show all the name starting by raj without pressing down arrow by mouse and from that list only we can select by down arrow key from key board. pl help because my list is 1000 numbers and very difficult to search

@officialpradeepjaat9761 2 года назад

Super explain 🥰🥰🥰🙏🏻👌🏻

@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

@ashiqmir2717 3 года назад

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

@kanhucharanadas3948 5 лет назад

Jabardast Dipak sir

@DeepakEduWorld 5 лет назад

😊😊😊

@uday1607 3 года назад

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

@pythusiast4701 3 года назад

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

@rajendrabendre6635 3 года назад

Superb video sir ✨✔️

@twinklejaiyswal5172 6 лет назад

Good and very simple tricks so very nice and good exaplane Thank you so mach Tack care Deepak sir

@shakilahmad7244 6 лет назад

Excellent h sir Aur bahut hi usefull bhi h

@dhananjaykumar-oj6xe 6 лет назад

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

@mithukhalifa7460 4 года назад

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

@nahednaddu2971 5 лет назад

Very Nice Explanation Concept fully understand

@sandeepgusain2154 4 года назад

bhut badiya tha.

@harshadvegda8097 3 года назад

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

@mwxfl45h33 Год назад

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

@akashkelkar1128 6 лет назад

aap to excel ke guru ho sir thank you

@aggarwal4943 5 лет назад

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

@luhif110 3 года назад

Very Good Explanation Keep up good work

@yuva3444 6 лет назад

Really very useful & explanation.

@goutamkarmoker4602 3 года назад

Nice teacher

@shashikantha1803 4 года назад

Superb, thanks for sharing and guiding

@EasyDTH 5 лет назад

Very intelligent bro..

@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.

@YOGESHTEACHER 5 лет назад

सर dependent searchable drop down list पर एक वीडियो बनाइए plz

@DeepakEduWorld 5 лет назад

Sure 👍👍

@jjevishal 5 лет назад

Dear sir, Very useful video I applied in my excel sheet. I am writing order of my client in excel sheet. I am.making new sheet everyday according to date. Items are repeated everyday. So I want this formula in each sheet by keeping search matter only in one sheet of items How to do please reply. According to above vedio I think I need to copy paste item list in each new sheet. Please clear confusion

@jaslokjha1410 10 месяцев назад

Thanks Deepak bhai❤

@fahimkhan357 6 лет назад

Very nice explain thank you so much

@srsandeepsinghnegi 6 лет назад

very nice video.

@subratapanda9195 2 года назад

Thank you sir jee

@starblack9419 3 года назад

Thank you so much

@TVSCDN Год назад

Thanks a million 🙏❤️👍🎉😍

@andydufresne4513 2 года назад

Aap master ho Sir

@naveedahmedvt3613 3 года назад

THANKS...EASILY UNDERSTOOD

@BakhtiarAUqaili 3 года назад

Very good formula and excellent way to teach us

@dkthetechiboy6505 3 года назад

Best sir i love it.

@DigiRuns 5 лет назад

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

@archanamuppidi14 6 лет назад

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

@dearloop1513 2 года назад

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

@gyanforyou7796 3 года назад

Thanks sir itta acha batane ke liye

@kiranbandekar2434 4 года назад

खूप छान सर

@ranganathprahlad 6 лет назад

You are a good teacher. Thank you very much.

@prabhakarpawar573 6 лет назад

Nice and very usefull video sirji

@imranomar207 3 года назад

A very knowledgeable video for excel lover . keep it up

@amiran280 6 лет назад

Your explanations are so good. Thank you sir. Please help me : How we can use this formula multiple cells of another sheet.

@Naturalist0 6 лет назад

Thanks Deepak ji, searcheable drop down list banana toh aapne sikha diya - lekin yeh toh ek single cell mein locked hai. Please bataiye isko drag down / dusri cell mein copy kaise karen.

@DeepakEduWorld 6 лет назад

Ys.. I will publish video shortly

@javed4sm 4 года назад

very good friend and thanks for your efforts to learn us

@santoshsawant4204 2 года назад

Great work. 🙏🏻🙏🏻🙏🏻

@AJEETKUMAR-dq1ur 6 лет назад

Dear Sir you are very expert in MS Excel Sir mai chahta hu ki type karte hi drop dwon ki list autometic khul jay jaise google me show hota ha

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XOzRCwyCkdA.html

@sarbchd9898 6 лет назад

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

@ajayint001 6 лет назад

Thank you so much sir....... Please ise our asan kaise kar sakte hai..isme formulas bahut use huwa h

@DeepakEduWorld 6 лет назад

+Ajay Kumar ok g.. I will publish video as soon as possible

@syedelyas7090 5 лет назад

Hai Deepak.. Precisely explained ty so much

@DeepakEduWorld 5 лет назад

☺️

@apshukla9 2 года назад

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

@trishnamoniroy5523 4 года назад

Thank u sir from Assam

@DILIPKISAN 6 лет назад

The way u describe, I never get bored

@DIOGOD28 2 года назад

Hi Deepak thanks bro for this beautiful video is amazing and you are an amazing teacher. What you showed have worked perfectly but I wanted to apply this feature for multiple cells. But somehow when I copy or apply it to the other cells it takes the input of the first selection. Is there a workaround for this? Also can this me be applied to a combo box or a list box. If you any videos on this please let me know. Thanks in advance

@JJ-gi8nx Год назад

zberdust bless you

@TheLibraannu 6 лет назад

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

@lakshatclasses7882 2 месяца назад

Very nice

@aryan123raj 3 года назад

very Nice....Excellent Deepak

@rajendrajomajipatil8314 2 года назад

Thanks a lot Sir for this video

@worldexpress9186 5 лет назад

sir aap bohat acha kaam kertay ho thanks

@conradgomes9081 4 года назад

This works only for one Cell (B3 in your tutorial), how can we make this work in multiple cells? TY in advance

@vishnuronge8447 3 года назад

Right how to make for entire column

@rishabhjain9160 2 года назад

Exactly ....only working for one cell

@pratikborkar 2 года назад

Any solution for this?

@sarveshmaurya5136 2 года назад

Exactly... How to create searchable dropdown list in multiple cells from the same database....???

@sofiankahn9522 3 года назад

That's all basic . Tell more about power query

@johnsonkv7734 4 года назад

REALLY GOOD AND IT IS ;HELPFUL

@HumanistLogic 2 года назад

Thanks bhai... you are awesome

@lahotanu 6 лет назад

SIR BAHUT HI BADIYA

@invinno8511 4 года назад

THANK YOU

@suhb6387 2 года назад

Sir, Deepak your master of excel

@bhushanara 6 лет назад

Complex hai sir , but bahut achha h

@ismailjanab9653 4 года назад

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

@sanjayadas7414 5 лет назад

So Inteligent u r ! Bro

@rastogi2006love 4 года назад

Bahut badhiya :)

@sazalsarkar2130 3 года назад

Wow Dada.

@FarahVision 6 лет назад

Too good deepak. but Thora sa easy kr k samjha den ye method plzz.. ye to boht tough hai...

@harneettradingco.1487 2 года назад

Thanks explained well

@68team 2 года назад

wo din tha jab me ne ise dekh ke separable listbox banaya tha . or ab VBA se yhi kam krta hun Bina kisi dout ke.. just one year deference 😅

@AnkitVerma-yd1xw 3 года назад

Thanks. Very nice.

@bibekanandamanna5442 3 года назад

Very nice....... Thanks

@dnyandeosomawanshi9271 6 лет назад

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

@sherazrathoor8552 6 лет назад

sir plz y video jaldi bty k hum kesa multipell cells p search able drop dwon list bna skta han or jb hum new item add kra tu wo b search ho use drop dwon list m

@kevinseeam4849 3 года назад

The best