Excel 2007 List Comparison

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a list of names and address in Excel 2007, some have which have been
modified/changed, ie addition of postcode, or streename spellings modified
etc. I cannot find a forumla or function which will enable
me to compare my before and after lists and be able to indicate row by row
what has changed. I need to do this for internal audit purposes, and I'm sure
this is possible in SQL but I have no SQL skills.

Does anyone know how I could do this?

Thanks
 
Well, for a quick and dirty comparison I just use some simple formulas.

Say I have a list on Sheet1 A1:C10 that I want to compare to the same range
on Sheet2. In cell E1 on Sheet1 I might enter this formula:
=IF(A1=Sheet2!A1,"","Changed") and copy it to E1:G10.
 
Back
Top