Using Count & Distinc formulas to
I'm having troubles trying to get the count from a list and showing in other sheet (For this image, I put it in the same sheet but I'll on other "data sheet"). In the other sheet; I would like to have the count of unique date related with de responsible Column "Resp". So if someone put any kind of task related with their name, is going to count but with the criteria of the initial date. So in the image you can see that "Diego" has a number 3, beacuse even if the task is the same names, he got 3 different dates , so in that way the formula has to recognize and related the "Resp" & "Initial date".
So if someone can help me, it would be awesome!
I hope I made myself clear,
Thanks in advance
Help Article Resources
Check out the Formula Handbook template!