4 Replies Latest reply on Jul 20, 2015 12:09 AM by Mira Shen

    Can I goup subjects who used multiple products under one field?

    Mira Shen

      Hello,

       

      I have subject using multiple products under one field as below

       

      Subject_ID      Products

      subj1                  A

      subj1                  B

      subj1                  C

      subj2                  A

      subj2                  C

      subj2                  D

      subj3                  B

      subj3                  D

      subj4                  B

      subj4                  D

       

      I like to group subjects like:

      if product=A AND product=C then Group="A+C"

      elseif product=B AND product=D then Group="B+D"

      ...

       

      Normal conditional function doesn't seem to work here.

       

      I am looking forward to your help. Thanks in advance.

       

      Best,

      Mira