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

[@raosatyapalrao8749]

Thanks

[@ComputerGyanGuruji]

Thanka

[@sanjitpaul2953]

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

[@loveislife4769]

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

[@sanjivshrivastava4270]

Excellent video in simple Hindi language.

[@sarveshdeshpande1772]

Perfect Example .... it helped me !!

[@dersgah8917]

Best solution ever ... thanks

[@jitendrabomble2218]

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

[@AlnawazInternational]

Excellent tutorial, Thanks for sharing.

[@Hari-n4f]

Clear and detailed explanation. Thanks

[@haribhairabari4013]

Very nice sir good job

[@Yogesh19Joshi]

Thank you Sir ...learnt a lot from this

[@devasyaenterprise1346]

very nice video.. i like it

[@mudalivenky1957]

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

[@khalidalisubhanallah2947]

Very knowledgeable video

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

[@hemrajbalwaria]

Nice clarification.

[@kishupatel2839]

Excellent..

[@excelknowledge367]

Good Job done

[@chetan1008]

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

[@mukeshkadkol4759]

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

[@artkaushal_fusion]

Thank You for sharing 🙏

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

[@HirenBalsara]

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

[@ShinySharmaKR]

Nice Sir

[@trickysportsbesttricks7383]

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

[@saleembukhsh7682]

Excellent

[@anishyadav1042]

Thank you

[@trickysportsbesttricks7383]

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

[@rahulkumar-gb8jq]

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

[@kamalkoli8937]

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

[@saradanimmagadda2542]

CAN U PLEASE EXPLAIN HOW TO CREATE SEARCHABLE DROPDOWN LIST IN EXCEL 365 USING MULTIPLE SHEETS

[@HirenBalsara]

Sir, search in a single cell but In my data required row wise search then pls guide 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

[@emadmadi1967]

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

[@xyz929]

Well done

[@CC-vd3mr]

How to make balance sheet consolidated in Excel for the year

[@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?

[@abhilashakhanna1815]

Sir,bahut fast teach karte hai aap

[@vivekgoyal-zd6qh]

Excel 2007 me filter wala formula kase add kare

[@futuresupport2271]

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

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

[@TheSudip1234]

Sir ye multiple cells pe Kam karega??

[@uniquemobiletipstricks7714]

Nice

[@shivamsingh6563]

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

[@prayash91]

How we can use this in VBA

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

[@momi3652]

How to copy this data validation to other cells

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

[@ilyasofficial4730]

Good

[@manishmishra6245]

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

[@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"

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

[@navinvyas5415]

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

[@computergayanbyprabodhkuma7426]

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

[@akhdigitech]

how to use it in another sheet?

[@arvindmevalaljaiswal7234]

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

[@ShinySharmaKR]

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

[@user-SH0099]

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

[@shivprasadsahu464]

How to use searchable dropdown list in multi cell.

[@akrampasha3322]

yeh sab formula cell phone me karke batao sir pls

[@faisalaminvirk6748]

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

[@k.g.maheshwar]

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

[@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]

[@adisbeekeeper]

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

[@abdulhamidalhaddadi2255]

Thank you

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