Forum Discussion
Solved
Count, but no duplicates and under 2 conditions
Hi, I have an Excel file with 3 columns. Colum A contains customer numbers. the customer numbers may appear several times. Column B contains numbers from 1-9 Column C either contains YES or is...
How about this Array Formula which requires confirmation with Ctrl+Shift+Enter and not Enter only.
=SUM(--(FREQUENCY(IF(B2:B8>=5,IF(C2:C8="YES",MATCH(A2:A8,A2:A8,0))),ROW(A2:A8)-ROW(A2)+1)>0))
How about this Array Formula which requires confirmation with Ctrl+Shift+Enter and not Enter only.
=SUM(--(FREQUENCY(IF(B2:B8>=5,IF(C2:C8="YES",MATCH(A2:A8,A2:A8,0))),ROW(A2:A8)-ROW(A2)+1)>0))
It works, thank you so much!!!!
You're welcome Tina_Charbon!
As variant with dynamic arrays
list of such customers
=UNIQUE(FILTER(B5:D11,(D5:D11="Yes")*(C5:C11>=5)))and number
=ROWS(F5#)assuming same customer - same class.
