Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel
How do I build a count calculation for column entries where duplicate items
are only counted once |
#2
|
|||
|
|||
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" wrote in message ... How do I build a count calculation for column entries where duplicate items are only counted once |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |