Counting unique names in the assign to column
I have the following project sheet. I would do a summary sheet that count the number of unique resources in the assigned to line item/task and then list it out for me.
The comprised data would have the following columns in it.
Assigned Name # of tasks
Jose Garcia 2
Brian Valania 1
Then i could used the summary data for a chart.
any thoughts on the formula to use. I know I will need to setup a reference
Help Article Resources
Check out the Formula Handbook template!