Count unique suppliers active / not active
Hi,
I'm trying to count the number of unique Third parties on a contract tracker sheet.
I want to be able to count the unique numbers of Third parties by Contract Group
So in the snip below:
- Supplier 3 and Supplier 4 would equal a count of 2 Not Active.
- Active would equal a count of 1
- Requested would equal a count of 2
- Future would equal a count of 2
I've tried various permutations using COUNT(DISTINCT(COLLECT…..
e.g., =COUNT(DISTINCT(COLLECT([Third Party]:[Third Party], [Contract Group]:[Contract Group], <>"2-Active")))
…but it is the bit where the suppliers are various Contract Groups that is the sticking point.
As ever, any thoughts would be great.
Answers
-
Are you putting this information in a metric sheet? Or on the current sheet?
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Hi Mark,
I'm going to put it in a metric sheet, so using the ranges, but also would like to solve it in it's own sheet, so I can have the option of summaries etc.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!