Sfoster924
New Member
- Joined
- Jun 28, 2022
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Hi All!
I am trying to create a formula where I can count unique "closed dates" (column D) based on if the Next steps " (column c) and "Group Name" are unique (No duplicates) with out using the remove duplicates function. I need the information for other aspects of the report.
In other words I want to know how many unique "close dates" occurred by each group name for all different options in the "next steps" Column. This report has several lines for the same close date and I want to count those as only 1 instance.
For Group F- The correct output would be : 1 cross functional meeting and 2 Drop in visit meeting ( I am ok with a formula for each type of meeting)
For group A - The correct output would be : 1 cross functional meeting because only one can be counted per day
I am trying to create a formula where I can count unique "closed dates" (column D) based on if the Next steps " (column c) and "Group Name" are unique (No duplicates) with out using the remove duplicates function. I need the information for other aspects of the report.
In other words I want to know how many unique "close dates" occurred by each group name for all different options in the "next steps" Column. This report has several lines for the same close date and I want to count those as only 1 instance.
For Group F- The correct output would be : 1 cross functional meeting and 2 Drop in visit meeting ( I am ok with a formula for each type of meeting)
For group A - The correct output would be : 1 cross functional meeting because only one can be counted per day