| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I compare two seperate spreadsheet files to identify diff
I have two seperate spreadsheet files I need to compare the two to identify
differences. Is there a way to do this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I compare two seperate spreadsheet files to identify diff
On the face of it, one quick n easy way to compare cell-by-cell is to use a
3rd sheet Assume the 2 source sheets to be compared are Sheet1 & Sheet2 In another new sheet, Put in A1: =--(Sheet1!A1=Sheet2!A1) Copy across/fill down as far as required to cover the corresponding used range in the source sheets. 1's will indicate same values, 0's show where its different Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Bob H" wrote: I have two seperate spreadsheet files I need to compare the two to identify differences. Is there a way to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare two versions of the same spreadsheet to see diff. | Excel Discussion (Misc queries) | |||
| Compare Excel files and spreadsheet 3rd party apps | Excel Discussion (Misc queries) | |||
| HOW DO I IDENTIFY DATA THAT IS DUPLICATED IN TWO SEPERATE WORKSHEE | Excel Discussion (Misc queries) | |||
| How do i compare two excel sheet and get it to show me diff. | Excel Discussion (Misc queries) | |||
| How can I 'diff' [compare content between] two Excel workbooks? | Excel Discussion (Misc queries) | |||
Linear Mode
