Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
Multiple worksheets within a workbook | Excel Worksheet Functions | |||
Appending external worksheets into existing workbook? | Links and Linking in Excel | |||
How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) |