Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2016, 07:01 PM
Ryga38 Ryga38 is offline Counting only the unique names in 3 columns on separate worksheets. Mac OS X Counting only the unique names in 3 columns on separate worksheets. Office 2016
Novice
Counting only the unique names in 3 columns on separate worksheets.
 
Join Date: Apr 2016
Location: Yungaburra
Posts: 1
Ryga38 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 04-15-2016, 07:21 AM
xor xor is offline Counting only the unique names in 3 columns on separate worksheets. Windows 10 Counting only the unique names in 3 columns on separate worksheets. Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Use a pivot table with multiple consolidation ranges (Alt D, P).
Reply With Quote
Reply

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
Counting only the unique names in 3 columns on separate worksheets. 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
Counting only the unique names in 3 columns on separate worksheets. Columns - separate management alvin Word 1 09-18-2012 09:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft