Count Function

JJP · Nov 19, 2003

HI

How can I count data in colums or rows without counting duplicat
values.

Thank Yo

Peo Sjoblom · Nov 19, 2003

One way

=SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&""))

JJP · Nov 19, 2003

Thanks Peo