Not including duplicates in a count

  • Thread starter Thread starter Dan in Oz
  • Start date Start date
D

Dan in Oz

G'day,

I have a spreadsheet that I use to keep training records. One of the columns
caontains a list of the companies represented in the training - there are
about 200.

In the bottom row, I have all the totals. But for the "Company" column, is
there a formula that I can use to count the participating companies i.e. not
counting the duplicates?

Any help will be much appreciated.

Thanks

Dan
 
This will count the unique entries in the range:

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