Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about Comparing Data
I have identical worksheets that I create every week. The only thing I change
is the backup data (weekly data). Then I open up last weeks worksheet and compare the two. Is there an easy way to compare and display the differences between two identical worksheets? Where it would say this week and last week we have a difference of 2k? And automatically pull in that information? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question about Comparing Data
I have a feeling that you are confusing workbooks and worksheets. Do you mean
2 worksheets or 2 workbooks? Workbooks are the files that are saved. Worksheets are the individual sheets within a workbook. Anyway to answer your question. (This will work whether the data is in separate worksheets within the same workbook or in worksheets in separate workbooks.) Because you say the 2 worksheets are identical, you could create a third worksheet where you insert a formula that subtracts the value of a cell on one worksheet from the value of the corresponding cell on another worksheet and drag this formula across the other cells for the size of the worksheets. Example:- Say you want to compare cell A2 on Sheet1 to cell A2 on Sheet2. In cell A2 on Sheet3 enter equal sign and then change sheets to Sheet1 and click cell A2. Then enter minus sign and change to Sheet 2 and click cell A2 then press Enter to complete the formula. Drag this formula across and then drag down to a size matching the data on sheets 1 and 2. The differences between the values will be displayed as positive or negative numbers where there is a difference or zero where the values are the same. To make it easy to read, you can then set the options to NOT display zeros so that only actual differences will be displayed. -- Regards, OssieMac "Adam" wrote: I have identical worksheets that I create every week. The only thing I change is the backup data (weekly data). Then I open up last weeks worksheet and compare the two. Is there an easy way to compare and display the differences between two identical worksheets? Where it would say this week and last week we have a difference of 2k? And automatically pull in that information? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing spreadsheets question | Excel Discussion (Misc queries) | |||
Question about comparing 2 cell values | Excel Discussion (Misc queries) | |||
Tricky comparing question | Excel Worksheet Functions | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
Comparing data in two columns and highlighting the data | Excel Worksheet Functions |