Not very good with excel other than a few simple things but have a sheet I need to do a compare with and wanted to use excel on this.
In the attached file I have 3 columns.
A: Country-one B:Country-two C:Region-two
Column B and C goes together where B is the Country and C is the Region that goes with B
I need to find out what Countries that is in Column B are not in the list of Countries in Column A and vise versa.
How can I make two new columns, D and E where i can (compare A and B)
Column D - contains what is in A but not B
Column E - contains what is in B but not in A
Thanks for any help