Using Count & Distinc formulas to

Diego Cardenas

Hello everyone!,

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

Diego

Ryan Sides

Hi @Diego Cardenas , give this one a try...

=COUNT(DISTINCT(COLLECT([Initial date]:[Initial date], Resp:Resp, "Diego Cardenas")))

This formula will work for your current sheet layout. If you want to cross reference to another sheet, just replace the ranges in the formula with your Cross Sheet Reference names.

Let me know if you run into any issues.

Ryan

Ryan Sides

Hi @Diego Cardenas , give this one a try...

=COUNT(DISTINCT(COLLECT([Initial date]:[Initial date], Resp:Resp, "Diego Cardenas")))

This formula will work for your current sheet layout. If you want to cross reference to another sheet, just replace the ranges in the formula with your Cross Sheet Reference names.

Let me know if you run into any issues.

Ryan

Diego Cardenas

@Ryan Sides Works perfectly!

Many thanks!

Diego

Ryan Sides

You're welcome! Happy to help.