#1
|
|||
|
|||
Counting only the unique names in 3 columns on separate worksheets.
I am making a client register for a homeless shelter. I get a total of individual clients at the end of each month. I do not want to count repeat clients twice. The clients names are in column C6:C36. For this I use the formula:
=SUMPRODUCT((C6:C36<>"")/COUNTIF(C6:C36,C6:C36&"")) I now need to develop a formula for the Quarterly report (separate worksheet) that gives only the individuals for the 3 month period (each month is on a separate worksheet) So if someone stayed in January and again in March, they should only be counted once. Is there a formula that can give the total number of individuals from 3 separate columns on different worksheets without counting repeat clients? |
#2
|
|||
|
|||
Use a pivot table with multiple consolidation ranges (Alt D, P).
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a list that contains duplicate and unique names without blanks | Iced42 | Excel | 1 | 06-30-2015 04:50 PM |
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
I need an index file containing the names of all the worksheets in a workbook. | retiredstuart | Excel | 3 | 09-12-2014 06:26 AM |
Need help counting text into separate columns. Screenshot Included | blackjack | Excel | 5 | 09-04-2014 10:49 PM |
Columns - separate management | alvin | Word | 1 | 09-18-2012 09:02 AM |