Counting without duplicates
Posted by Lewis on January 30, 2002 4:54 PM
Hey
Whats the best way to count a group of cells not accepting duplictes?? Say the data was NY, NY, NY CA
the sum would be 2
thanks
-Lewis
Posted by Juan Pablo G. on January 30, 2002 6:35 PM
If your data is in A1:D1 use
=SUM(IF(LEN(A1:D1),1/COUNTIF(A1:D1,A1:D1)))
Array entered.
Juan Pablo G.
