Comparing two columns

A

AA Arens

Hi, hope you can help me with my problem. I have tried with commends but failed so far.

I have two columns with names

How to show in a third column those values deleted in, and in the fourth column, those added to the second column compared to the 1 column.
The values in the two columns may not be in the same order.


A: B: C: D:
(Del) (Added)

tree cup home cup
home car bus
car bus
tree


Thank you for your help.

Bart
Excel 2013
 
Top