Thread: Excel

How do I build a count calculation for column entries where duplicate items
are only counted once

Try this:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Robin Faulkner" <RobinFaulkner@discussions.microsoft.com> wrote in message
news:98983D1C-823F-49F4-B1D0-5B7385CD38A0@microsoft.com...
How do I build a count calculation for column entries where duplicate items
are only counted once