Excel 2007 List Comparison

[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

 

[Jim Rech]

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.

 

[Evgeny Grischenko]

Hi!
I am not that skilled in Excel, so usually use some add-ins found in the
Internet. This one compares spreadsheets:
http://www.office-excel.com/excel-addins/compare-spreadsheets.html
Hope it helps!

Evgeny