Intelligent Data Validation 👍 - The WOW Technique 😮

Data Validation is one of the most important tools in Excel to create dynamic Reports and Dashboards.
Until recently, we had to prepare for creating Drop Lists, by extracting a List of unique Values. Not any more.
In this Tutorial, I show you what we have been doing for decades, then what we recently did with Dynamic arrays and Finally what we currently do.
So let's have a look
You can read my Blog by clicking on the link:
You can Download the Exercise File and follow along :
To book a Corporate Training at Client Site or Remote, and get a quote:
Please support this channel by Subscribing, Liking and Commenting.

[mohitjagad]

Thank you for sharing this awesome tutorial.
Getting rid of the blanks (0) from the unique filtered value, using DROP is something new i learned today. Thanks.
And latest method you shared is above all 👌👍.
Thanks for sharing.

[short_excel]

Thank you for providing valuable information. Regarding the issue of getting 0 when referring to empty cells in the UNIQUE function, the formula below seems to be simpler for removing it.
=TOCOL(UNIQUE(C2:C64), 1)

[Luciano_mp]

Yes...Wow, nice Technique. Thank you Nabil.

[ALG_]

جميل جدا، أفكار رائعة
الحمد لله على العودة بعد غياب طويل
إن شاء الله تكون بصحة و عافية

[IvanCortinas_ES]

Times evolve, in this case, for the better. Thanks Nabil for this tutorial.

[gandhisunil]

Thanks Nabil for amazing explaination

[magdahassib]

Thank you so much, you always come with new ideas

[alializadeh]

Please teach us some Ms Access techniques.... 😊

[nadermounir]

Thank you Nabil for this great video. Using Filter function could be a good option in irder to remove all the zeros, especially if we have many of them