Forum Discussion
Solved
Count unique values among duplicates with 1 condition
Hi expertise, I have a problem which is to count the unique job number under ticket type "C" as below. Answer should be "TWO" due to Job Number 3 & 4 both are under Ticket Type C. I knew the fo...
You can also try the following formula if you have Office 365...
=COUNT(UNIQUE(FILTER(A2:A11,B2:B11="C")))
You can also try the following formula if you have Office 365...
=COUNT(UNIQUE(FILTER(A2:A11,B2:B11="C")))thank you so much !
I got the answer by using your formulathanks for great helps
You're welcome Lawrence_Lam_320! Glad it worked for you.
Please take a minute to accept the post with the proposed answer as the Best Response to mark your question as Solved,
