Not including duplicates in a count
 

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

Not including duplicates in a count
 

This will count the unique entries in the range:

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

--
Biff
Microsoft Excel MVP


"Dan in Oz" <Dan in wrote in message
...
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