Week on Week % Increase Calculated in a Single Cell.

[BREW78]

Hello,


I want to calculate the Week on Week (WoW) percentage increase/decrease in a single cell.


My table has Week Numbers running across the columns i.e. WK01 - WK02 - WK03... and different models running down the rows.


For example, I want to calculate the percentage increase/decrease in sales from WK01 to WK02 in a single cell with the percentage increase/decrease updating each progressing week.


Appreciative of any advise.


BREW78.

 

[Hui]

Brew78


Firstly, Welcome to the Chandoo.org forums.


Wow increases is (W02-W01)/W01 then formatted as %


So if you are using a formula and want to automatically index the headers of the table

you will need a formula like:

=(INDEX(B4:K4,,MATCH("W"&TEXT($C$1,"00"),$B$3:$K$3,0))-INDEX(B4:K4,,MATCH("W"&TEXT($C$1-1,"00"),$B$3:$K$3,0)))/INDEX(B4:K4,,MATCH("W"&TEXT($C$1-1,"00"),$B$3:$K$3,0))

Luckily I have made a sample file for you

Download it here: https://www.dropbox.com/s/rm0ef01t86vc0aj/WOW.xls

 

[BREW78]

Hui,


Thanks for the welcome and prompt response.


I'll try your suggestion and let you know how I get on.


Thanks again,

BREW78.