AnsweredAssumed Answered

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

Question asked by user24799 on Jun 6, 2016
Latest reply on Jun 7, 2016 by 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

Outcomes