4 Replies Latest reply: Sep 9, 2015 4:41 AM by Sunny Talwar RSS

    Count problem

    Kenny Tang

      Hi Folks,

       

      I have a question where not sure how to get the result and need your help !

       

      Result should be  3

       

      data :

      A    B    C  D                      should be counted

      1  1    1    9                            No (A=1)

      2  1    1    8                            Yes

      2  1    1    7                            No (duplicate from last row,  B=1 C=1 )

      2  2    1    6                            Yes

      2  1   2    5                            Yes

       

       

      Criteria

       

      Count only  "once for  B  within  same C" and A =2

       

      Thx in advanced gurus