Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie : Comparing two spreadsheets
I am using Excel 97.
I need to compare two different worksheets. The worksheets represent daily sales activity. Column A in both worksheets represents the customer ID, Column B is product description and Column C is sales amount. If the Customer ID (Column A) in yesterday's data appears again in today's worksheet, I am to compare the sales (Column C ). I am to substract yesterday's sales from today sales. The new report is to appear in another worksheet like the example below. Customer ID Item Description Sales 1 Bonds $1,000,000 2 Stocks ($100,000) Any ideas how to approach this problem. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie : Comparing two spreadsheets
Take a look at =Vlookup()
You can do something like this in column D: =IF(ISERROR(VLOOKUP(A1,[book2.xls]Sheet1!A$1:C$999,3,FALSE)),0, VLOOKUP(A1,[book2.xls]Sheet1!A$1:C$999,3,FALSE)) where book2.xls, sheet1, A1:c999 contained yesterday's numbers. Then use column E to do your subtraction. Rich wrote: I am using Excel 97. I need to compare two different worksheets. The worksheets represent daily sales activity. Column A in both worksheets represents the customer ID, Column B is product description and Column C is sales amount. If the Customer ID (Column A) in yesterday's data appears again in today's worksheet, I am to compare the sales (Column C ). I am to substract yesterday's sales from today sales. The new report is to appear in another worksheet like the example below. Customer ID Item Description Sales 1 Bonds $1,000,000 2 Stocks ($100,000) Any ideas how to approach this problem. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two spreadsheets | Excel Worksheet Functions | |||
COMPARING SPREADSHEETS | Excel Discussion (Misc queries) | |||
comparing two spreadsheets | Excel Discussion (Misc queries) | |||
Please Help (Comparing Spreadsheets) | Excel Worksheet Functions | |||
Comparing 2 spreadsheets | Excel Programming |