how to compare data and see variances by year

A

ayse

Hi,

I am working on a spread sheet that has worksheets for months.
Each worksheet (month) has 2007, 2008, 2009 data.
I want to be able to see the varience between 2007-2008 and 2008-2009.

The column headers on each worksheet sheet are:
2007
A1=Company B1=producer code C1=Total(dollar amount)

2008
E1=Company F1=producer code G1=Total

2009
I1=Company J1=producer code K1=Total

In short I would like to match the producer codes and if they match I would
like to calculate the difference between 2007-2008 and 2008-2009totals.


How do I manage that?


Thank you in advance,

Ayse
 
I

igorek

You need an array formula "{}" that will compare multiple ranges and act if
result is found.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Attempting to compare and deduct values based on date codes 3
how do I sort excell files by date? 1
Complicated nested row formula - Multiple Range Compare 2
List to a table format 6
VLOOKUP and Referencing a Range in a Formula 2
How can a drop down list be linked to values on another sheet? 1
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0

Top