6 Replies Latest reply on Dec 13, 2013 9:48 AM by Andrew Ball

    Find item that exist in BOTH category else display none

    Avijit Paul

      Hi,

      I am trying to find a taskID that exists in both category and not just one.

       

      So lets say in the following example, task ID 389042 exist in both Relevant but other and Not Relevant.

       

      taskIDIDcategory
      3890423.98534E+17Relevant but Other
      3890423.98534E+17Relevant but Other
      3890423.98534E+17Not Relevant / Skip
      3890423.98534E+17Not Relevant / Skip
      3890423.98534E+17Relevant but Other
      3890433.98534E+17Relevant but Other
      3890433.98534E+17Not Relevant / Skip
      3890433.98534E+17Not Relevant / Skip
      3890433.98534E+17Relevant but Other
      3890433.98534E+17Relevant but Other
      3890433.98534E+17Relevant but Other
      3890443.98534E+17Relevant but Other
      3890443.98534E+17Not Relevant / Skip
      3890443.98534E+17Not Relevant / Skip
      3890443.98534E+17Relevant but Other
      3890443.98534E+17Damaged
      3890443.98534E+17Damaged
      3890453.98534E+17Relevant but Other
      3890453.98534E+17Damaged
      3890453.98534E+17Damaged
      3890453.98534E+17Damaged
      3890453.98534E+17Damaged

       

      I have used "Contains" to put as quick filter but that shows all entries and not those that I can find with an "AND"

       

      So what I am trying to achieve is, "which items exist both in the 'Relevant but Other' as well as 'Not Relevant / Skip' and it should show me

       

      389042

      389043

      389044

       

      Thanks a lot.

       

      I have added the dummy data in excel file as well.