| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compare & then sum/list differences between spreadsheets?
I have a spreadsheet that is updated & sent to me weekly.
Up until now I have been comparing the two sheets side by side and cutting & pasting the differences into a new spreadsheet to summarize/list the differences. Now the spreadsheet is becoming larger and taking more time I am guessing there is a way to quickly compare the two sheets & sum the differences? Can some kind soul please explain to an Excel idiot how to achieve this please? ;^) -- Thanks & regards, -pp- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to compare & then sum/list differences between spreadsheets?
Take a look here for some ideas:
http://www.cpearson.com/excel/duplic...CountingUnique (there are other "aids" on Chip's site) Are the differences always additions only or can items be removed. And what data needs to be compared and summated "Pheasant PluckerĀ®" wrote: I have a spreadsheet that is updated & sent to me weekly. Up until now I have been comparing the two sheets side by side and cutting & pasting the differences into a new spreadsheet to summarize/list the differences. Now the spreadsheet is becoming larger and taking more time I am guessing there is a way to quickly compare the two sheets & sum the differences? Can some kind soul please explain to an Excel idiot how to achieve this please? ;^) -- Thanks & regards, -pp- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| differences between spreadsheets | Excel Discussion (Misc queries) | |||
| how do i compare two excel spreadsheets to indicate differences | Excel Worksheet Functions | |||
| how do I find the differences in two spreadsheets | Excel Discussion (Misc queries) | |||
| How do I compare excel spreadsheets, tracking the differences? | Excel Worksheet Functions | |||
| Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
Linear Mode
