Thread
:
counting unique items
View Single Post
#
1
tjtjjtjt
Posts: n/a
counting unique items
I've seen formulas like this posted as a solution for counting unique items
in a column:
=SUMPRODUCT((A1:A20000<"")/COUNTIF(A1:A20000,A1:A20000&""))
What purpose does the &"" at the end serve?
--
tj
Reply With Quote