how to compare 2 worksheets in 1 workbook
I'm trying to figure out how to find any difference in 2 (or more) worksheets
in one workbook (file). These are text files. |
how to compare 2 worksheets in 1 workbook
If you can ensure that both worksheets are in the same sequence by
sorting them using the same column(s), then in a third worksheet you can enter into A1 a formula like: =IF(Sheet1!A1=Sheet2!A1,"","different") This formula can be copied across for as many columns as you have, and can be copied down for as many rows as you have. Any differences between the two sheets will be pointed out to you in the appropriate cell. Hope this helps. Pete |
how to compare 2 worksheets in 1 workbook
Personally, I would use Jim Cone's fine commercial Add-in called XL
Companion. It's available at http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "Treasur2" wrote: I'm trying to figure out how to find any difference in 2 (or more) worksheets in one workbook (file). These are text files. |
All times are GMT +1. The time now is 06:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com