R
renegade
I have laid out a table containing 50 data on a monthly for a period of 5
years. I intend to calculate growth rate calculated over the same period in
different years.
So Row 1 contains: Jan-02, Feb-02, Mar-02, ...Jan-03, Feb-03, ...
So the growth rate I intend to calculate would be Jan-03/Jan-02,
Jan-04/Jan-03, Feb-03/Feb-02, and so on... Is there a function which could
locate and trigger the right data and then calculate? Thanks!
years. I intend to calculate growth rate calculated over the same period in
different years.
So Row 1 contains: Jan-02, Feb-02, Mar-02, ...Jan-03, Feb-03, ...
So the growth rate I intend to calculate would be Jan-03/Jan-02,
Jan-04/Jan-03, Feb-03/Feb-02, and so on... Is there a function which could
locate and trigger the right data and then calculate? Thanks!