| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
| How can I count numbers without including the repeated values? | Excel Discussion (Misc queries) | |||
| count them number of cells between values -2 and 2 including 0 | Excel Discussion (Misc queries) | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Linear Mode
