Forum Discussion

Tina_Charbon's avatar
Tina_Charbon
Copper Contributor
Jul 07, 2020
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...
excel
Formulas and Functions
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Jul 07, 2020

    Tina_Charbon 

     

    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))

     

Tina_Charbon's avatar
Tina_Charbon
Copper Contributor
Jul 07, 2020

 It works, thank you so much!!!!

Resources