View Single Post
  #1   Report Post  
tjtjjtjt
 
Posts: n/a
Default 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