2 Replies Latest reply on Jun 7, 2016 12:37 AM by user24799

    Can I compare two fields that contain (a list of names) and see only the names that have changed?

    user24799

      Is this possible?

       

      Here is an example of what I am trying to do:

       

      Field A =

      Adam

      John

      Mary

      Meg

       

      Field B =

      John

      Adam

      Josh

      Steve

       

      (The order of the names might change between Field A and Field B.)

       

       

      DESIRED RESULTS

       

      Field C = Who was removed Calc

      Mary

      Meg

       

      Field D = Who was added Calc

      Josh

      Steve