Thread: Counting number of items excluding duplicates.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Counting number of items excluding duplicates.
Hi,

Am Thu, 17 Oct 2013 06:42:22 -0700 (PDT) schrieb :

Product
A
A
A
B
C
C
F
E

your products in column A with header. Then try:
=SUMPRODUCT((A2:A200<"")/COUNTIF(A2:A200,A2:A200&""))



Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote