Hello Everyone,
Just joined this forum.
I Googled out the below formula that counts the number of unique text values from a list. While it does work perfectly fine, but i am unable to understand the logic working behind this formula, especially the reason for using SUMPRODUCT function and A:A&"".
=SUMPRODUCT((A:A<>"")/COUNTIF(A:A,A:A&""))-1
Any explanation will be greatly appreciated.
Bookmarks