Forum Discussion
Solved
count clients by code
Hi everyone, I am trying to count the number of clients that have a certain code. I see how to count the number of codes that is in the "# of ees" column. but in the column to the left, it shoul...
- I believe this is what you're looking to do:
=COUNTA(UNIQUE(FILTER($I$9:$I$32,$J$9:$J$32=N8)))
PowerPivot can also make short work of this with Distinct Count.
I believe this is what you're looking to do:
=COUNTA(UNIQUE(FILTER($I$9:$I$32,$J$9:$J$32=N8)))
PowerPivot can also make short work of this with Distinct Count.
=COUNTA(UNIQUE(FILTER($I$9:$I$32,$J$9:$J$32=N8)))
PowerPivot can also make short work of this with Distinct Count.