How To Create Searchable Drop Down List In Excel | Searchable data validation in excel

How To Create Searchable Drop Down List In Excel | Searchable data validation in excel.
#datavalidation #dropdownlist #advancedexcel #computergyanguruji
practice file download link:-drive.google.com/file/d/1Dgm5...
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic

[@sanjivshrivastava4270]

Excellent video in simple Hindi language.

[@loveislife4769]

आपके सभी वीडियो अत्यधिक जानकारीपूर्ण हैं. मैं आपसे एक्सेल का उपयोग करके इनवॉइस जनरेशन और डेटाबेस प्रबंधन के बारे में सीखना चाहता हूं।

[@sanjitpaul2953]

Very good video. You have tought the simplest way to produce blank free list. This will be a great help. Thank you Sir.

[@sarveshdeshpande1772]

Perfect Example .... it helped me !!

[@manissery1956]

Clear and detailed explanation. Thanks

[@jitendrabomble2218]

Thanks sir. Very useful information. 👌👌👍👍🌹🌹

[@dersgah8917]

Best solution ever ... thanks

[@AlnawazInternational]

Excellent tutorial, Thanks for sharing.

[@Yogesh19Joshi]

Thank you Sir ...learnt a lot from this

[@devasyaenterprise1346]

very nice video.. i like it

[@anishyadav1042]

Thank you

[@haribhairabari4013]

Very nice sir good job

[@khalidalisubhanallah2947]

Very knowledgeable video

[@hemrajbalwaria]

Nice clarification.

[@excelknowledge367]

Good Job done

[@artkaushal_fusion]

Thank You for sharing 🙏

[@kishupatel2839]

Excellent..

[@uniquemobiletipstricks7714]

Nice

[@prakashkarnik9305]

Sir , would this drop down list applicable to multiple cells in a sheet ? Please clarify . Thanks ..you are too good at clarifying basics on the topics you touch .

[@mukeshkadkol4759]

Super sir , agar list nahi but array ho to kaam karega ??

[@ShiningSharma]

Nice Sir

[@saleembukhsh7682]

Excellent

[@xyz929]

Well done

[@raosatyapalrao8749]

Thanks

[@ComputerGyanGuruji]

Thanka

[@emadmadi1967]

Thank you very much for your valuable information. I do appreciate your effort for giving us these lessons.

[@mudalivenky1957]

आपसे कैसे संपर्क करें । आपके सारे विडियो बहुत अच्छा है ।

[@trickysportsbesttricks7383]

Realy Nice, but I want to make searchable dropdown list. is it possible shortly, guide me.

[@ilyasofficial4730]

Good

[@user-hx8ub1eu6t]

If I want this formula in continue rows for different data then or I can use the same formula next cell also possible

[@abhilashakhanna1815]

Sir,bahut fast teach karte hai aap

[@computergayanbyprabodhkuma7426]

Sir, what is the difference between product function and mmult function explain examples..

[@user-hx8ub1eu6t]

Sir, search in a single cell but In my data required row wise search then pls guide me

[@kamalkoli8937]

kya hum drop down list ko a to z sort kr sakte hai ????

[@trickysportsbesttricks7383]

Realy nice, but I want to make multiple searchable dropdown list. Is it possible shortly, guide me.

[@fahadkhalid8924]

It must be applicable to multiple cell, but it only for one cell.

[@idealaccounttaxsolutions858]

very good, but How to set every row, Because I need to search name for every row's entry

[@devhaldar6507]

Dear Sir, Can we use created hyperlink into another system. For example- I make data and attached multiple photo's with the help of hyperlink and share that file to some one though email. Can they can able to use that hyperlink on his/her system.

[@CC-vd3mr]

How to make balance sheet consolidated in Excel for the year

[@rahulkumar-gb8jq]

@ComputerGyanGuruji Any formula for select multiple value from dropdown list without VBA or MACRO.

[@arvindmevalaljaiswal7234]

Dear sir. Namaskar. Bahut achchha video banaya hai aapne like to banta hai. Sir eska advance kuchh banaeye jaise esme surch box me likhne par hi drop down list ban jaye esme drop down list surch karna padta hai. Dusra jaise Rajasthan state surch karu to dusra drop down zila ka ban jaye jo usme feed kiya gaya ho aur usko inter karne par box me feed ho jaye please sir es par video banaiye.

[@ComputerGyanGuruji]

upload soon

[@ambayoilcompany9278]

DEEPAK KI 'HOW TO MAKE DEPENDENT DROP DOWN LIST DEKHO'.

[@futuresupport2271]

sir mujhe dusri sheet pr drowdoun list banna hai or 40 row me lagana hai

[@akhdigitech]

how to use it in another sheet?

[@shivamsingh6563]

Sir what is the wildcard for numbers Please tell me 🙏🙏

[@hasansyed3136]

Kia 2nd sheet sy bhi same way mai searchable drop down list Bana saktay hai like data on 2nd sheet and drop down on other

[@TheSudip1234]

Sir ye multiple cells pe Kam karega??

[@prayash91]

How we can use this in VBA

[@shivprasadsahu464]

How to use searchable dropdown list in multi cell.

[@navinvyas5415]

How can create only first character searchable drop down list in ms excel 2007 in hindi

[@deepakbhanushali1]

what if "B2" is not fix and goes on increasing as in input data in i.e i want to do the above video proceudure in all the colums "B"

[@manishmishra6245]

I have a sheet which updates everyday , to usme 20 names ki jagah next day 25 names aa jaayenge to kaise hoga ye

[@safeerahmed8252]

I have a simple list in cell A2 its values are “Yes” and “No”. I want this cell A2 as mandatory; mean it should never be empty. But a problem is there, when I press delete from keyboard, it deletes list element from said cell and no error is displayed. How can I do it with data validation WITHOUT USING VBA?

[@faisalaminvirk6748]

Other tab par offset formula data validation main work nahi kar raha.

[@manojsable8482]

sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable

[@chetan1008]

16:40 offset video Link in i button 👍👍👍

[@ShiningSharma]

2007 version ke liye chahie use per yah Kam nahin kar mujhe pure column mein dropdown chahie

[@k.g.maheshwar]

मैं आपके पूरे वीडियो देखा लेकिन मुझे जो जानकारी चाहिए वो नही मिल पा रहा है। कृपया मेरा सवाल का उत्तर देने का कष्ट करेंगे

[@thewoodelement6183]

SIR PLEASE HELP, WHEN I PASTE OFFSET FORMULA IN DATA VALIDATION THAN ERROR LIKE (the source currently evaluates to an error)

[@ComputerGyanGuruji]

plz try correctly

[@user-SH0099]

Data validation isn't working show this one(the source currently evaluation to an error)

[@akrampasha3322]

yeh sab formula cell phone me karke batao sir pls

[@arvindmevalaljaiswal7234]

गुड सर. सर राइट किलीक ना करके सेल मे लिखने पर ही नीचे ड्राप डाउन लिस्ट बनती जाए ऐसा कुछ बनाइये🙏 प्लीज सर.

[@rameshmeena7582]

good morning sir i want that with the help of drop down list the whole sheet or selected data can be changed and in its place other data will come please send video related to it

[@Its.my.pleasure]

बहोत complicated hai. ईसाका VBA code banao सर

[@msghildiyal8798]

गुरूजी यदि हम दोस्तो को गूगल शीट साझा करें , तो दोस्त हमारी शीट पर कोई फोटो कैसे अपलोड कर सके

[@ComputerGyanGuruji]

noted

[@DILIPPATEL-ou5hh]

Sir aap email address sent kijie me aapko ek excel file batana chahtu hu kyoki usi excel file me cell me jitne number likho utni hi row open hoti he

[@ComputerGyanGuruji]

[e-mail]

[@0103984181500]

This is unusefull because its only for one cell so its crap

[@manojsable8482]

sir namaste .exel me 5 ya 6 row me item no wise data hai aur o data randam hai matlab pahela item 2 no,dusra item 1no tisra 4 aur choutha item 3 ( ye data single row me nahi hai ) ise one tine without cut pase sirial no se kaise banaye pls guide me manoj sable