Growth function that get known Y's from two columns?

I know a lot of people are not fond of using helper cells. IMO, however, the easiest way to do this will be to use a helper column that will scan through A and B, locate the "Y" values as you've shown them, and put them into a single column. Then it will be easy to use the GROWTH function on that column. Assuming the layout is similar to what you want, column D could have =A1. Copy that down to D19. Then D20 =B20. Then your =GROWTH(D1:D20).

Originally Posted by MrShorty

I know a lot of people are not fond of using helper cells. IMO, however, the easiest way to do this will be to use a helper column that will scan through A and B, locate the "Y" values as you've shown them, and put them into a single column. Then it will be easy to use the GROWTH function on that column. Assuming the layout is similar to what you want, column D could have =A1. Copy that down to D19. Then D20 =B20. Then your =GROWTH(D1:D20).

Ok, maybe I should have mentioned this earlier, but I have to be able to ctrl-down the formula. The Y's in my example are only part of the first growth-function. In reality, the values in A and B go down a lot further. So, what I want is a column C with a Growth-formula that starts in row 10 for example (using the values from row 1 to 10), and ends in row 1000 or so.