How to compare large, simple excel sheets..

[mag7417]

Does anyone know how to do that? I have to compare two sheets (5 columns
by 2000 rows).

The first three rows contain a number or two. Nothing more. The next
two contain text (requirements actually) and I need to compare the
contents of all the cells. Have any text changed? Been removed? Added?

I know there are some plugins or stand alone products that can help me
with this but those I have looked at have been a little too fancy. I am
looking for something that can help me with this relatively simple
sheet.

Any help could save me weeks worth of work.


Thanks!

 

[Pete_UK]

If you think the two sheets are nearly identical, then you can add a
third sheet with a formula like this in A1:

=IF(Sheet1!A1=Sheet2!A1,"","different")

then copy this across your five columns and then copy the 5 cells down
2000 rows.

If cells on the two sheets are the same then you will just have a blank
- otherwise you will have the word "different", which will help you to
home in to those cells.

Hope this helps.

Pete

 

[Guest]

I use Jim Cone's fine commercial Add-in for this sort of thing.......it
"saves me weeks of work".....it's available at

http://www.realezsites.com/bus/primitivesoftware/

Vaya con Dios,
Chuck, CABGx3