Compare and Display Similarities/Differences in two lists.

**mrgillus** · 07-24-2009, 11:27 AM

I have searched some of the other forums but have not found anything specifically related to what I'm trying to do.. An example is attached. Basically just want to compare data between two different lists and then in two additional columns (Differences & Similarities) display that corresponding data.

Thanks for the Help...

**JBeaucaire** · 07-24-2009, 12:38 PM

1) Are you looking to do this with formulas or a macro?
2) Can you update your sample sheet to include your expected results so we know what you have in mind?

**mrgillus** · 07-24-2009, 01:29 PM

I was looking to do this using some spreadsheet formulas.

I decided though to change the way I wanted to compare the results.

I have it setup now the way that will best work for me I believe and I attached a copy so that users searching for answers on this might beable to benefit from what I have done.

Basically it will check for changes from one list to the next and in a nutshell tell you if some of the numbers have been omitted from one list to the next or if they have been added.

Thanks for your help though!

**JBeaucaire** · 07-24-2009, 02:50 PM

The helper columns are not needed. The CF formula for column C starting at C2 is:
=NOT(AND(C2>0,ISNUMBER(MATCH(C2,D:D,0))))

The CF formula for column D starting at D2 is:
=NOT(AND(D2>0,ISNUMBER(MATCH(D2,C:C,0))))