Compare 2 similar excel worksheets

[Nadia]

How do I compare 2 similar excel worksheets?
Both have identical rows and colums, the text may differ in text row, kindly
assist?

[Bernard Liengme]

See Chip's stuff at www.cpearson.com
He seems to be down at the moment!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nadia" <[email protected]> wrote in message
news:[email protected]...
> How do I compare 2 similar excel worksheets?
> Both have identical rows and colums, the text may differ in text row,
> kindly
> assist?

[CLR]

I use Jim Cone's fine commercial Add-in called XL Companion for this sort of
thing. It's available at

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

.......works fine, lasts a long time.......

Vaya con Dios,
Chuck, CABGx3


"Nadia" wrote:

> How do I compare 2 similar excel worksheets?
> Both have identical rows and colums, the text may differ in text row, kindly
> assist?

[Bernie Deitrick]

Nadia,

Make a third worksheet, and in cell A1, use the formula

=Sheet1!A1=Sheet2!A1

and copy that formula for as large a range as is used on sheet1 and sheet2. Then find the FALSE
values and they will indicate which cells are different.

HTH,
Bernie
MS Excel MVP


"Nadia" <[email protected]> wrote in message
news:[email protected]...
> How do I compare 2 similar excel worksheets?
> Both have identical rows and colums, the text may differ in text row, kindly
> assist?