Forum Discussion
Solved
Distinct Count number of completed Goals when all Task statuses in Goals are marked as completed
Good Day Excel users, what approach and formula can i use to solve this challenge on my subject (Distinct Count number of completed Goals when all Task statuses in Goals are marked as completed ). ...
See the attached version. I added a helper column to the first sheet.
I used formulas that will work in all versions of Excel. It would be easier in Excel 365.
Hi,
Please find this file. This will automatically update the results as you extend or change the main data.
Certain functions used in this will work only in Excel 365.
Thank you!!