Comparing two columns


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

Thank you for your help.

Excel 2013

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question