Count the total number of task a member being assigned to when one task may assigned to two people
What formula can I use to consolidate the number of task assigned for each member? Because i unable to write a good formula, then I need to form all these possibility combination. I have more than 20 combination and it is difficult for the member to read in the chart.
Help Article Resources
Check out the Formula Handbook template!