Unbelievable... 5 Different Drop Lists in One Single Cell

[@GeertDelmulle]

Just when you think you’ve seen everything about dynamic dropdown lists,… Nabil Murad comes along and shows you the next level…! Thanks, this was great!! :-)

[@Officeinstructor]

Wow, thank you! What a nice comment from an EXPERT Thanks for watching Geert

[@GeertDelmulle]

@@Officeinstructor It’s videos like these that humbles a man: there’s always a bigger fish -er- expert. I mean expert. ;-)

[@aljumaiahahmed7858]

شرح رائع وواضح ومميز في طرح الموضوع

[@Officeinstructor]

شكرا علي المشاهدة و يشرفني إشتراكك في القناة… أتمني من كل إخوتي بالمنطقة العربية مشاركة فيديوهاتي لمساعدتي علي إصدار المزيد… تحياتي

[@tamerghounem1181]

thank you

[@Officeinstructor]

You're welcome

[@mayjornales8685]

Nabil is the MASTER JEDI of XL. Keep being amazing, Nabil!

[@Officeinstructor]

Thank you May. You too keep being a motivating subscriber :)

[@mggabar5127]

Thank you, Nabil. You are a MASTER.

[@Officeinstructor]

You are very welcome

[@navedsaiyed9881]

you nailed it Murad i was looking for something like this to handle my list of items to show when selected particular items falling under it

[@Officeinstructor]

Glad it was helpful

[@IvanCortinas_ES]

I've been following Nabil since he started on KZbin. You are one of the best. Thanks for so many hours of knowledge.

[@Officeinstructor]

Wow, thank you! If you were my ONLY subscribers... I will continue sharing my knowledge

[@akulomnarayan6663]

Intellect follows intellect : )

[@yosefk2864]

Not one of the best, THE best!

[@patrickschardt7724]

I have seen many drop down list videos, from the old school "static" versions, to the partially dynamic versions (using big ranges, OFFSET, etc), and the fully dynamic Mircosoft 365 versions. This is by far the most amazing version I have ever seen. Fantastic job, Nabil I never new about the XLOOKUP spill range operator trick

[@Officeinstructor]

Thank you for the nice comment Patrick. I am happy you enjoyed this tutorial and found value in it.

[@nadermounir8228]

Thank u Nabil. Amazing new stuff 👌

[@Officeinstructor]

You are welcome

[@EricHartwigExcelConsulting]

This is amazing and boarders on the edge of pure Excel magic! Fantastic video! Thank you so much for sharing/creating this!

[@Officeinstructor]

Thank you so much for this nice comment

[@tobayekaina8610]

Hi NABIL thanks for sharing

[@Officeinstructor]

My pleasure

[@YouExcelTutorials]

Now this is truly amazing! Thanks for sharing Nabil! 💪

[@Up4Excel]

This is excellent, such a clever use of functions Nabil. I was convinced you were going to use VBA to achieve this but you actually manage it with relatively well known functions and dynamic arrays. Great stuff 👍 Also it's a brilliant alternative to dependant dropdowns.

[@Officeinstructor]

Thanks for the feedback. Much appreciated

[@Luciano_mp]

Brilliant! Thank you very much Nabil!

[@Officeinstructor]

Always welcome

[@iankr]

Wow, this is brilliant! Many thanks. 👏

[@Officeinstructor]

Thanks for watching

[@armotxa124]

Thank you Nabil 👍

[@Officeinstructor]

My pleasure

[@martyc5674]

Brilliant Nabil. Superb video - validation wizardry, I’m going to have to try and find a use for this one it’s so good!!

[@Officeinstructor]

Fantastic! I am very glad you enjoyed my tutorial

[@crispomwangi6297]

Breath-taking😍

[@Officeinstructor]

Glad you liked it

[@sasavienne]

The best video ever :) Brilliant ideas .. Thanks a lot for sharing this stunning stuff.

[@waelelsayed7155]

Thank you dear for sharing amazing ideas 😍

[@Officeinstructor]

My pleasure 😊

[@CeliaAlvesSolveExcel]

This is so good, Nabil! Thank you for sharing this technique.

[@Officeinstructor]

My pleasure! Thank you Celia for visiting my channel.

[@yosefk2864]

Indeed mind blowing!

[@OzduSoleilDATA]

Nabil! You are spooky. How do you think this stuff up? 😯😁

[@Officeinstructor]

Oh my friend thanks for watching... Everything begins with an idea... I work hard on it... The magic comes next

[@OzduSoleilDATA]

@@Officeinstructor you're full of ideas and magic. Keep it coming.

[@zaighamuddinfarooqui1705]

Always amazing. 💕

[@mdexcelpro8495]

How to say no words your are genius

[@Officeinstructor]

Thank you for the compliment

[@francktalbot797]

bjr comment faite vous pour la somme car j ai toutes les sommes excepte les sommes du 1er critere

[@Officeinstructor]

kzbin.info/www/bejne/iKLGf36fjc-toZo

[@rina1592]

Hi....the outcome is brilliant but it didn't go into my head and that is my problem 😀

[@Officeinstructor]

You just need to get a coffee and watch it another time. Thanks for watching

[@rina1592]

@@Officeinstructor 😀

[@SolomonKinyanjui_sk]

Good work

[@Officeinstructor]

Thanks

[@SolomonKinyanjui_sk]

@@Officeinstructor you're welcome

[@wayneedmondson1065]

Hi Nabil. An awesome video! Thanks so much for sharing this technique. Truly brilliant! Thumbs up!! PS - I went to your public download site, but did not see a link for the exercise file. Hope you post it soon. Thanks again :))

[@Officeinstructor]

Hi Wayne. Thanks for the great feedback. The exercise file is now available on the OfficeInstructor website.

[@wayneedmondson1065]

@@Officeinstructor Awesome! Thank you :))

[@VijayKumar-zd7ou]

I think this is a unique video solute to you Nabil Sir. And sir u know that last time requested to u please make the drop down on shapes and red highlight on clicking others shapes light grey colour highlights drop down look like web page.

[@Officeinstructor]

Thanks Vijay for the recommendation, however I have a very long list of tutorials i wish to create, every tutorial takes from 7 to 10 days of work... but I will add your request to the list

[@rhaps2008]

Awesome!!

[@ellukayou]

Impresionante realmente

[@Officeinstructor]

Glad you enjoyed it

[@macaunutritionassociation]

is it possible to create a searchable drop down list for this method? it might be very difficult right ?

[@alializadeh8195]

Thanks

[@Mohamed-km9jd]

Can i get the home in top ?

[@redhaakhund1271]

⭐️⭐️⭐️⭐️⭐️

[@izzat_kiswani]

Realy Incredible !!!! , Thanks For Sharing!!!!

[@alializadeh8195]

Thanks