Forum Discussion
Solved
Need Help
Hi all expertise,
I need your help as I have a excel problem. I would like to count the job number (unique) under the following criteria.
Job Type = A
Payment = Cash
Answer should be 2 as Job number 123 & 124 met the criteria. May i ask your help to share the formula with count, unique and filter to me? I tried to use the formula but not correct. Thanks
=COUNT(UNIQUE(FILTER(A:A, B:B="A", C:C="Cash")))
| Colume A | Colume B | Colume C | |
| Job Number | Job Type | Payment | |
| 123 | A | Cash | |
| 124 | A | Cash | |
| 124 | A | Cash | |
| 124 | A | Cash | |
| 125 | B | Visa | |
| 126 | B | Visa |
Hi HansVogelaar,
Thank you so much, you helped me to fix this issue. Thanks
2 Replies
It should be
=COUNT(UNIQUE(FILTER(A:A, (B:B=E2)*(C:C=F2))))
Hi HansVogelaar,
Thank you so much, you helped me to fix this issue. Thanks
