How To Create Searchable Drop Down List In Excel | Searchable data validation in excel
HTML-код
- Опубликовано: 11 сен 2024
- How To Create Searchable Drop Down List In Excel | Searchable data validation in excel.
#datavalidation #dropdownlist #advancedexcel #computergyanguruji
practice file download link:-drive.google.c...
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
Very good video. You have tought the simplest way to produce blank free list. This will be a great help. Thank you Sir.
आपसे कैसे संपर्क करें । आपके सारे विडियो बहुत अच्छा है ।
आपके सभी वीडियो अत्यधिक जानकारीपूर्ण हैं. मैं आपसे एक्सेल का उपयोग करके इनवॉइस जनरेशन और डेटाबेस प्रबंधन के बारे में सीखना चाहता हूं।
Excellent video in simple Hindi language.
Perfect Example .... it helped me !!
Best solution ever ... thanks
Thanks sir.
Very useful information.
👌👌👍👍🌹🌹
Clear and detailed explanation. Thanks
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 .
Excellent tutorial, Thanks for sharing.
Thank you Sir ...learnt a lot from this
very nice video.. i like it
Very nice sir good job
Very knowledgeable video
Super sir , agar list nahi but array ho to kaam karega ??
Nice clarification.
Good Job done
Thank You for sharing 🙏
Excellent..
Thanks
Thanka
Nice Sir
CAN U PLEASE EXPLAIN HOW TO CREATE SEARCHABLE DROPDOWN LIST IN EXCEL 365 USING MULTIPLE SHEETS
Excellent
Thank you
Thank you very much for your valuable information. I do appreciate your effort for giving us these lessons.
Realy Nice, but I want to make searchable dropdown list. is it possible shortly, guide me.
Well done
Sir,bahut fast teach karte hai aap
Nice
If I want this formula in continue rows for different data then or I can use the same formula next cell also possible
kya hum drop down list ko a to z sort kr sakte hai ????
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.
upload soon
DEEPAK KI 'HOW TO MAKE DEPENDENT DROP DOWN LIST DEKHO'.
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.
Good
Realy nice, but I want to make multiple searchable dropdown list. Is it possible shortly, guide me.
Sir, search in a single cell but In my data required row wise search then pls guide me
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
It must be applicable to multiple cell, but it only for one cell.
@ComputerGyanGuruji
Any formula for select multiple value from dropdown list without VBA or MACRO.
very good, but How to set every row, Because I need to search name for every row's entry
How to copy this data validation to other cells
Excel 2007 me filter wala formula kase add kare
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
How to make balance sheet consolidated in Excel for the year
Sir ye multiple cells pe Kam karega??
How we can use this in VBA
sir mujhe dusri sheet pr drowdoun list banna hai or 40 row me lagana hai
I have a sheet which updates everyday , to usme 20 names ki jagah next day 25 names aa jaayenge to kaise hoga ye
16:40 offset video Link in i button
👍👍👍
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?
Sir, what is the difference between product function and mmult function explain examples..
how to use it in another sheet?
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"
Sir what is the wildcard for numbers
Please tell me 🙏🙏
मैं आपके पूरे वीडियो देखा लेकिन मुझे जो जानकारी चाहिए वो नही मिल पा रहा है। कृपया मेरा सवाल का उत्तर देने का कष्ट करेंगे
How to use searchable dropdown list in multi cell.
Data validation isn't working show this one(the source currently evaluation to an error)
गुड सर.
सर राइट किलीक ना करके सेल मे लिखने पर ही नीचे ड्राप डाउन लिस्ट बनती जाए ऐसा कुछ बनाइये🙏 प्लीज सर.
yeh sab formula cell phone me karke batao sir pls
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
How can create only first character searchable drop down list in ms excel 2007 in hindi
Other tab par offset formula data validation main work nahi kar raha.
2007 version ke liye chahie use per yah Kam nahin kar mujhe pure column mein dropdown chahie
SIR PLEASE HELP, WHEN I PASTE OFFSET FORMULA IN DATA VALIDATION THAN ERROR LIKE (the source currently evaluates to an error)
plz try correctly
गुरूजी यदि हम दोस्तो को गूगल शीट साझा करें , तो दोस्त हमारी शीट पर कोई फोटो कैसे अपलोड कर सके
noted
बहोत complicated hai. ईसाका VBA code banao सर
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
jangirgolums2@gmail.com
This is unusefull because its only for one cell so its crap
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