Compare 2 similar excel worksheets
How do I compare 2 similar excel worksheets?
Both have identical rows and colums, the text may differ in text row, kindly assist? |
Compare 2 similar excel worksheets
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" wrote in message ... How do I compare 2 similar excel worksheets? Both have identical rows and colums, the text may differ in text row, kindly assist? |
Compare 2 similar excel worksheets
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? |
Compare 2 similar excel worksheets
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" wrote in message ... How do I compare 2 similar excel worksheets? Both have identical rows and colums, the text may differ in text row, kindly assist? |
All times are GMT +1. The time now is 07:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com