CookieMonster76
Board Regular
- Joined
- Apr 30, 2015
- Messages
- 195
Hi
I have a report that comes out like this:
It shows employees hand training courses they need to do.
I need to summarise it to tell me how many unique employees there are, which i have done like this:
IFERROR(ROWS(UNIQUE(FILTER(M:M,O:O="Sales"))),0)
However, I would then like to exclude anyone who is marked as "Yes" in Col J.
So the end result should be
Sales 0
Finance 1
IT 1
Can the above formula be amended to do this?
Thanks
Paul
I have a report that comes out like this:
It shows employees hand training courses they need to do.
I need to summarise it to tell me how many unique employees there are, which i have done like this:
IFERROR(ROWS(UNIQUE(FILTER(M:M,O:O="Sales"))),0)
However, I would then like to exclude anyone who is marked as "Yes" in Col J.
So the end result should be
Sales 0
Finance 1
IT 1
Can the above formula be amended to do this?
Thanks
Paul