Hi, I'm looking for a formula that will pick up the most recent data in a row of columns and then increase that value by 5%.
So for example in column 'Value' in the table below it would pick up 23 in 'Quantity 2' and increase that value by 5%, 78 in 'Quantity 3' and increase that value by 5% and so on.
So for example in column 'Value' in the table below it would pick up 23 in 'Quantity 2' and increase that value by 5%, 78 in 'Quantity 3' and increase that value by 5% and so on.
Quantity 1 | Quantity 2 | Quantity 3 | Quantity 4 | Quantity 5 | Quantity 6 | Value |
12 | 23 | |||||
33 | 67 | 78 | ||||
33 | 67 | 78 | 104.3333 | |||
67 | 78 | |||||
12 |