Intelligent Data Validation 👍 - The WOW Technique 😮

[@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.

[@Officeinstructor]

You are most welcomed. Thanks for watching

[@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)

[@Officeinstructor]

Nice Formula, Thanks for sharing

[@Luciano_mp]

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

[@Officeinstructor]

I'm glad you liked it

[@ALG_1983]

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

[@Officeinstructor]

شكرا علي السؤال. الحمد للّه انا بخير و شكرا للمتابعة

[@IvanCortinas_ES]

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

[@Officeinstructor]

Glad you liked it!

[@alializadeh8195]

Thanks

[@Officeinstructor]

Welcome

[@gandhisunil3]

Thanks Nabil for amazing explaination

[@Officeinstructor]

My pleasure

[@magdahassib694]

Thank you so much, you always come with new ideas

[@Officeinstructor]

Thank you! Cheers!

[@alializadeh8195]

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

[@Officeinstructor]

Sure 😊

[@nadermounir8228]

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

[@Officeinstructor]

Yes, you are right