Dynamic Dependent Drop-Down Lists in Excel | Expandable & Exclude Blank Cells | Using offset match
HTML-код
- Опубликовано: 11 сен 2024
- Dynamic Dependent Drop-Down Lists in Excel | Expandable & Exclude Blank Cells | Using offset match formula and dynamic with counta formula
#dropdownlist #dependentdropdownlist #advancedexcel #computergyanguruji
Offset 1
• Offset Function in Exc...
Offset+MATCH
• Offset Match Formula i...
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 Word
• MS Word
MS PowerPoint
• MS Power Point
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
a great farmula. i applied and i done this farmula. so great making report. thanks sir
Sir your knowledge is awesome.
it's very useful. Thanks
Best Explanation !!!!!!!
Very Nice Video. 👌👌👌
Very informative
Good work
bahut acchhhe
Sir stock maintain ka format batye with detail
Sir, thankyou for the video. Mujhe ye problem aa rahi hai ki jab main formula baaki rows mein copy karta hun to wo first row ko hi replicate karta hai jise copy kiya. Agar first row ko change kiya to baaki sab rows mein dependent dropdown same dikhata hai. Har row ke first column ki value change karne se 2nd column ki value change nahi hoti.
Please share dynamic dependant dropdown list to practice; also make it searchable.
very nice
Nice Video
It's given the file for excel tutorial, sir. Thanks
Thanks
Nice video 👍
Sir , Plz provide more than 2 dependent drown list along with deletion of blank cells in the drop down list
Best
Please make a video on auto suggest list as you type. Means just by typing a character the auto suggest list is updated.
ruclips.net/video/C6LvyFHMDLI/видео.html
Thank you sir
🙏🙏💓💓🙏🙏
Sir want to learn Ms Access completely if you help me.
Sir plz same videos on vba plz sir
hamne VBA ki series suru ki hui hain, keep watching
Lock kaise kiya aapne plz tell
Provide a video on making dependent drop-down list on Google sheet.
Hi sir I can able to copy same formula in below row
sir google sheet per kam nhi kr rha formula
hello guru ji........... please give me a tips of making family chart in laptop windows 7
How to make height dynamic inside match function sir pls give me some guidance
Please Share Any Example For More Than 5 Dependent Drop Down List In VBA Form With Code.
Dependent drop down list with offset
Why sometimes not working this formula, and instead we can use indirect also, do one more video for this
How to add long paragraphs of text in drop down
Sir , I want multi dependent drop down list.
Sir , ye formula me next row me kaise copy kare
The counta formula doest not count the cells for each column, it shows 10 which you used in the 4th parameter, I also tried to leave that parameter blank, it showed 1 for all selection :( Please HELP ME I tried all the ways and nothing seems to work. PS: My OS is MAC
Sir very nice video, plz tell how we can add more countries after bangladesh.
Everytime I add everytime change formula. How to do it dynamically ? Sir plz 🙏
Ok, stay tuned
@@ComputerGyanGuruji sir jee i am still waiting
Hi bro, bhai plz ek dynamic dependent down list banaeay jis mai countries k names double mai hon, jis tara ap ne countries k names mai Pakistan and UK lika hy, es tara double names mai banaeay plz q k dependent drop down list mai underscore sign use keay baghair name enter nai hota...tnx
Your drop down list not sorted a-z.
Nhi hua