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

[CLR]

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




"mag7417" wrote:

>
> 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!
>
>
> --
> mag7417
> ------------------------------------------------------------------------
> mag7417's Profile: http://www.excelforum.com/member.php...o&userid=28413
> View this thread: http://www.excelforum.com/showthread...hreadid=531901
>
>