Count Unique Entries Multiple Criteria

Jennifer Lindquist

I would like to count the number of unique employees who have submitted an entry per quarter.

Here's the formula I tried:

=COUNT(DISTINCT(COLLECT(Employee:Employee, YRQtr:YRQtr, YRQtr@row, [Idea Approved/Denied]:[Idea Approved/Denied], "Approved")))

Always returns a value of 1.

Screenshot 2024-10-09 103810.jpg

SSFeatures

Hi @Jennifer Lindquist,

I just tested out your formula and it worked perfectly for me:

=COUNT(DISTINCT(COLLECT(Employee:Employee, YRQtr:YRQtr, YRQtr@row, Status:Status, "Approved")))

Can you try creating a second sheet with just a couple rows and columns, and see if the formula works for you on a different sheet? Maybe something is going on with your main sheet that we need to figure out.

Cheers!

SSFeatures

Hi @Jennifer Lindquist,

I just tested out your formula and it worked perfectly for me:

=COUNT(DISTINCT(COLLECT(Employee:Employee, YRQtr:YRQtr, YRQtr@row, Status:Status, "Approved")))

Can you try creating a second sheet with just a couple rows and columns, and see if the formula works for you on a different sheet? Maybe something is going on with your main sheet that we need to figure out.

Cheers!

Jennifer Lindquist

It did work in a new sheet. Odd.

So… I ended up referencing the current sheet to a new sheet and got it to work. Thank you, but I really wish it would've worked on the original.

SSFeatures

You're welcome! You can try deleting your YrQtr column and your Column10, then recreating those columns and re-adding the data back in. This is a super weird bug though!