Hello All,
So today my boss told me that he wanted a just a cell that displays YTD YOY growth. So essentially here is what we're working with for excel tables.
Now I need to get the YOY amount and Growth % displayed just once in cell each. But I need it to be dynamic. So for example if we're putting data for May into the sheet, the cell will display the growth % and YOY for 2022 up until May. I might be super unclear in explaining this. (also I am aware that Pivot tables are much easier to manipulate in this regard, but the guy that signs my paycheck wants this format). Any help or sense of direction would be greatly appreciated.
So today my boss told me that he wanted a just a cell that displays YTD YOY growth. So essentially here is what we're working with for excel tables.
Year | January | February | March | April | May | June | July | August | September | October | November | December | Total |
2017 | $ 16,186.00 | $ 20,262.00 | $ 19,763.00 | $ 17,349.00 | $ 16,098.00 | $ 16,590.00 | $ 16,930.00 | $ 16,151.00 | $ 11,336.00 | $ 20,398.00 | $ 20,309.00 | $ 20,199.00 | $ 211,571.00 |
2018 | $ 16,331.00 | $ 16,566.00 | $ 16,281.00 | $ 18,645.00 | $ 16,706.00 | $ 18,708.00 | $ 18,655.00 | $ 17,813.00 | $ 18,833.00 | $ 17,529.00 | $ 17,858.00 | $ 18,140.00 | $ 212,065.00 |
2019 | $ 18,140.00 | $ 19,461.00 | $ 22,933.00 | $ 22,933.00 | $ 20,587.00 | $ 22,003.00 | $ 22,309.00 | $ 21,785.00 | $ 22,409.00 | $ 19,931.00 | $ 21,236.00 | $ 20,223.00 | $ 253,950.00 |
2020 | $ 20,247.00 | $ 21,908.00 | $ 22,661.00 | $ 18,234.00 | $ 18,011.00 | $ 21,137.00 | $ 19,018.00 | $ 20,781.00 | $ 19,979.00 | $ 19,975.00 | $ 20,336.00 | $ 16,980.00 | $ 239,267.00 |
2021 | $ 17,698.00 | $ 20,284.00 | $ 18,400.00 | $ 25,722.00 | $ 18,964.00 | $ 19,638.00 | $ 20,636.00 | $ 20,835.00 | $ 18,041.00 | $ 16,671.00 | $ 16,809.00 | $ 17,000.00 | $ 213,698.00 |
2022 | |||||||||||||
YOY +/- | =[Jan-2022]-[Jan-2021] | Display results of the formula here | |||||||||||
Growth % | |
Now I need to get the YOY amount and Growth % displayed just once in cell each. But I need it to be dynamic. So for example if we're putting data for May into the sheet, the cell will display the growth % and YOY for 2022 up until May. I might be super unclear in explaining this. (also I am aware that Pivot tables are much easier to manipulate in this regard, but the guy that signs my paycheck wants this format). Any help or sense of direction would be greatly appreciated.