I think i'm making this more difficult than it is.
I have an 2 excel spreadsheets with sales numbers like this -
Zip CustomerType Sec Hes Fol
10001 S 0 303.23 0
10002 C -37 3461.39 1531.8
10577 S -71.25 287.56 0
11211 C 0 702.22 0
11803 L 14 365.27 -45
12401 S 0 280.99 0
12524 W 0 178.32 0
One file is numbers I averaged over the past 3 months. The other file is actual numbers. Not all zip codes are in each file. I need to figure out the difference between the 2 and add the difference to this months numbers. So I created a query and found there were 94 records that matched based on zip cod and customer type. Then I found the difference in sales amounts. Now I'm stuck at figuring out which zip code and customer type don't match in the 2 files. So if zip code 10001 with customer type S isn't in the actual data for this month I need to add the zip code and customer type and have it be -303.23.
I have an 2 excel spreadsheets with sales numbers like this -
Zip CustomerType Sec Hes Fol
10001 S 0 303.23 0
10002 C -37 3461.39 1531.8
10577 S -71.25 287.56 0
11211 C 0 702.22 0
11803 L 14 365.27 -45
12401 S 0 280.99 0
12524 W 0 178.32 0
One file is numbers I averaged over the past 3 months. The other file is actual numbers. Not all zip codes are in each file. I need to figure out the difference between the 2 and add the difference to this months numbers. So I created a query and found there were 94 records that matched based on zip cod and customer type. Then I found the difference in sales amounts. Now I'm stuck at figuring out which zip code and customer type don't match in the 2 files. So if zip code 10001 with customer type S isn't in the actual data for this month I need to add the zip code and customer type and have it be -303.23.
