How to compare large, simple excel sheets..

M

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!
 
P

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
 
Top