How to calculate changes in the value

[Myura]

Hi!
I want to calculate changes in the prices of companies. (one year change). My table looks like this
Date-------Company-------Price
2001-------A----------------20
2002-------A----------------25
2001-------B----------------30
2002-------B----------------35

So i have to calculate the % changes of the price change.
%chg of A at 2002 = (25-20)/20

Here I know I have to use filters to make sure they do not mix up companies. But I do not know how to do it.

Please help me to do this.

Thanks in advance

 

[anglais428]

Is it always just two years?

 

[Myura]

Is it always just two years?

No. It will be around 15 years of data. Also years also will not be uniform (Not all the companies will have all 15 years data points)

 

[anglais428]

If you first filter the data so that all the companies are order A-Z and then by year (lowest-highest) then try (in cell D3)
=IF(B3=B2,(C3-C2)/C2,"") and autofill

where B3 is the second cell in the company column, B2 is the first cell in the column column; C3 is the second cell in the price column; C2 is the first cell in the price column

This will leave a blank where the company changes and add the % growth if the company is the same