Тёмный
No video :(

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

Computer Gyan Guruji
Подписаться 404 тыс.
Просмотров 96 тыс.
50% 1

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

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

 

5 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 75   
@mudalivenky1957
@mudalivenky1957 7 месяцев назад
आपसे कैसे संपर्क करें । आपके सारे विडियो बहुत अच्छा है ।
@sanjitpaul2953
@sanjitpaul2953 3 года назад
Very good video. You have tought the simplest way to produce blank free list. This will be a great help. Thank you Sir.
@loveislife4769
@loveislife4769 7 месяцев назад
आपके सभी वीडियो अत्यधिक जानकारीपूर्ण हैं. मैं आपसे एक्सेल का उपयोग करके इनवॉइस जनरेशन और डेटाबेस प्रबंधन के बारे में सीखना चाहता हूं।
@sanjivshrivastava4270
@sanjivshrivastava4270 Год назад
Excellent video in simple Hindi language.
@sarveshdeshpande1772
@sarveshdeshpande1772 Год назад
Perfect Example .... it helped me !!
@dersgah8917
@dersgah8917 2 года назад
Best solution ever ... thanks
@uniquemobiletipstricks7714
@uniquemobiletipstricks7714 6 месяцев назад
Nice
@mukeshkadkol4759
@mukeshkadkol4759 Год назад
Super sir , agar list nahi but array ho to kaam karega ??
@jitendrabomble2218
@jitendrabomble2218 3 года назад
Thanks sir. Very useful information. 👌👌👍👍🌹🌹
@prakashkarnik9305
@prakashkarnik9305 3 года назад
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 .
@trickysportsbesttricks7383
@trickysportsbesttricks7383 Год назад
Realy Nice, but I want to make searchable dropdown list. is it possible shortly, guide me.
@AlnawazInternational
@AlnawazInternational Год назад
Excellent tutorial, Thanks for sharing.
@user-hx8ub1eu6t
@user-hx8ub1eu6t 10 месяцев назад
Sir, search in a single cell but In my data required row wise search then pls guide me
@manissery1956
@manissery1956 2 года назад
Clear and detailed explanation. Thanks
@devasyaenterprise1346
@devasyaenterprise1346 Год назад
very nice video.. i like it
@haribhairabari4013
@haribhairabari4013 2 года назад
Very nice sir good job
@khalidalisubhanallah2947
@khalidalisubhanallah2947 3 года назад
Very knowledgeable video
@excelknowledge367
@excelknowledge367 7 месяцев назад
Good Job done
@user-hx8ub1eu6t
@user-hx8ub1eu6t 10 месяцев назад
If I want this formula in continue rows for different data then or I can use the same formula next cell also possible
@hemrajbalwaria
@hemrajbalwaria 2 года назад
Nice clarification.
@raosatyapalrao8749
@raosatyapalrao8749 Год назад
Thanks
@ComputerGyanGuruji
@ComputerGyanGuruji 11 месяцев назад
Thanka
@Yogesh19Joshi
@Yogesh19Joshi 2 года назад
Thank you Sir ...learnt a lot from this
@momi3652
@momi3652 27 дней назад
How to copy this data validation to other cells
@kishupatel2839
@kishupatel2839 3 года назад
Excellent..
@ShiningSharma
@ShiningSharma Год назад
Nice Sir
@artkaushal_fusion
@artkaushal_fusion 2 года назад
Thank You for sharing 🙏
@anishyadav1042
@anishyadav1042 Год назад
Thank you
@vivekgoyal-zd6qh
@vivekgoyal-zd6qh Месяц назад
Excel 2007 me filter wala formula kase add kare
@trickysportsbesttricks7383
@trickysportsbesttricks7383 Год назад
Realy nice, but I want to make multiple searchable dropdown list. Is it possible shortly, guide me.
@devhaldar6507
@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.
@rahulkumar-gb8jq
@rahulkumar-gb8jq Год назад
@ComputerGyanGuruji Any formula for select multiple value from dropdown list without VBA or MACRO.
@saleembukhsh7682
@saleembukhsh7682 3 года назад
Excellent
@kamalkoli8937
@kamalkoli8937 Год назад
kya hum drop down list ko a to z sort kr sakte hai ????
@CC-vd3mr
@CC-vd3mr Год назад
How to make balance sheet consolidated in Excel for the year
@safeerahmed8252
@safeerahmed8252 10 месяцев назад
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?
@fahadkhalid8924
@fahadkhalid8924 Год назад
It must be applicable to multiple cell, but it only for one cell.
@arvindmevalaljaiswal7234
@arvindmevalaljaiswal7234 3 года назад
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
@ComputerGyanGuruji 3 года назад
upload soon
@ambayoilcompany9278
@ambayoilcompany9278 3 года назад
DEEPAK KI 'HOW TO MAKE DEPENDENT DROP DOWN LIST DEKHO'.
@hasansyed3136
@hasansyed3136 2 года назад
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
@abhilashakhanna1815
@abhilashakhanna1815 Год назад
Sir,bahut fast teach karte hai aap
@emadmadi1967
@emadmadi1967 3 года назад
Thank you very much for your valuable information. I do appreciate your effort for giving us these lessons.
@futuresupport2271
@futuresupport2271 2 года назад
sir mujhe dusri sheet pr drowdoun list banna hai or 40 row me lagana hai
@user-SH0099
@user-SH0099 9 месяцев назад
Data validation isn't working show this one(the source currently evaluation to an error)
@xyz929
@xyz929 3 года назад
Well done
@ilyasofficial4730
@ilyasofficial4730 3 года назад
Good
@akhdigitech
@akhdigitech 2 месяца назад
how to use it in another sheet?
@chetan1008
@chetan1008 2 года назад
16:40 offset video Link in i button 👍👍👍
@idealaccounttaxsolutions858
@idealaccounttaxsolutions858 3 года назад
very good, but How to set every row, Because I need to search name for every row's entry
@prayash91
@prayash91 3 года назад
How we can use this in VBA
@manojsable8482
@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
@manishmishra6245
@manishmishra6245 Год назад
I have a sheet which updates everyday , to usme 20 names ki jagah next day 25 names aa jaayenge to kaise hoga ye
@navinvyas5415
@navinvyas5415 3 года назад
How can create only first character searchable drop down list in ms excel 2007 in hindi
@deepakbhanushali1
@deepakbhanushali1 2 года назад
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"
@computergayanbyprabodhkuma7426
@computergayanbyprabodhkuma7426 3 года назад
Sir, what is the difference between product function and mmult function explain examples..
@shivprasadsahu464
@shivprasadsahu464 2 года назад
How to use searchable dropdown list in multi cell.
@TheSudip1234
@TheSudip1234 3 года назад
Sir ye multiple cells pe Kam karega??
@shivamsingh6563
@shivamsingh6563 3 года назад
Sir what is the wildcard for numbers Please tell me 🙏🙏
@thewoodelement6183
@thewoodelement6183 3 года назад
SIR PLEASE HELP, WHEN I PASTE OFFSET FORMULA IN DATA VALIDATION THAN ERROR LIKE (the source currently evaluates to an error)
@ComputerGyanGuruji
@ComputerGyanGuruji 3 года назад
plz try correctly
@ShiningSharma
@ShiningSharma Год назад
2007 version ke liye chahie use per yah Kam nahin kar mujhe pure column mein dropdown chahie
@akrampasha3322
@akrampasha3322 2 года назад
yeh sab formula cell phone me karke batao sir pls
@rameshmeena7582
@rameshmeena7582 3 года назад
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
@faisalaminvirk6748
@faisalaminvirk6748 3 года назад
Other tab par offset formula data validation main work nahi kar raha.
@arvindmevalaljaiswal7234
@arvindmevalaljaiswal7234 3 года назад
गुड सर. सर राइट किलीक ना करके सेल मे लिखने पर ही नीचे ड्राप डाउन लिस्ट बनती जाए ऐसा कुछ बनाइये🙏 प्लीज सर.
@k.g.maheshwar
@k.g.maheshwar 3 года назад
मैं आपके पूरे वीडियो देखा लेकिन मुझे जो जानकारी चाहिए वो नही मिल पा रहा है। कृपया मेरा सवाल का उत्तर देने का कष्ट करेंगे
@msghildiyal8798
@msghildiyal8798 3 года назад
गुरूजी यदि हम दोस्तो को गूगल शीट साझा करें , तो दोस्त हमारी शीट पर कोई फोटो कैसे अपलोड कर सके
@ComputerGyanGuruji
@ComputerGyanGuruji Год назад
noted
@Its.my.pleasure
@Its.my.pleasure 3 года назад
बहोत complicated hai. ईसाका VBA code banao सर
@DILIPPATEL-ou5hh
@DILIPPATEL-ou5hh 3 года назад
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
@ComputerGyanGuruji 3 года назад
jangirgolums2@gmail.com
@adisbeekeeper
@adisbeekeeper 2 года назад
This is unusefull because its only for one cell so its crap
@manojsable8482
@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
Далее
Searchable drop-down list for multiple cells
13:23
Просмотров 159 тыс.
La Tierra Robó El Anillo De Saturno #planetballs
00:14
🔎 How to Create Searchable Drop Down List in Excel
18:37
Make a Search Bar in Excel to Find Anything!
10:35
Просмотров 358 тыс.
Searchable Drop Down Lists in Excel (No VBA) 🔥
2:57