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")))
=SUMPRODUCT(IFERROR(1/(COUNTIFS(A2:A11,A2:A11,B2:B11,"=C")),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
thanks for your great help