A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | Price 2017 | Price 2018 | Price 2019/01 | Price change | Price 2019/02 | Price change | Price 2019/03 | Price change | Price 2019/04 | Price change | Price 2019/05 | Price change | Price 2019/06 | Price change |
2 | 20 | 22 | 23 | 4.5% | 25 | 8.7% | 25 | 0.0% | 25 | 0.0% | ||||
3 | 20 | 22 | 0.0% | 0.0% | 0.0% | 25 | 13.6% | |||||||
4 | ||||||||||||||
5 |
<tbody>
</tbody>
I need the price changes to calculate of the last price value. Data example
In Row 2 the price changed 4.5% from 2019/01 to 2018 & 8.7% in 2019/02 from 2019/01
In row 3 the first price change in column I - 2019/04 at 13.6%.
Question what formula can I use the find the last value which is 22 in 2018 (column B ) & exclude all the percentages?
Thank you
IanPM