Count unique contributors in 2 columns
Hi,
I am trying to count the number of unique contributors to a project.
Our structure requires us to use 2 contact list columns, with only one entry per row (no multiple contacts in a cell)
The 2 columns are Assigned To, and Collaborator. They are several columns apart.
In some instances the lead on one aspect (Assigned To) may be a Collaborator on another part of the project
I am trying to count the TOTAL number of UNIQUE project team members.
I can easily use COUNT and DISTINCT to get one column individually - but cannot seem to be able to manage 2.
Help?
Answers
-
For context - the outcome I would want is a count of 3 based on the view above. There are 3 total unique contributors in this view.
-
I would suggest hidden helper columns that are next to each other with basic cell references set as column formulas. Then you can select the double column range in your COUNT/DISTINCT.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!