Exponential Growth Formula with Different Years

[ExcelBonehead]

I have growth displayed in rows:

2.00 2.75 3.25 5.50 6.75
3.25 4.25 6.35 7.50

Has anyone designed a formula to calculate the exponential growth (easy if all the rows have the same years - but here the second row has only three compared to the first one which has four (its the intervals I'm counting here)). As I need to copy down for 400+ rows (each with between 1 and 5 intervals (ie 2 to 6 years of data) it becomes very onerous to change each row's formula by hand to adjust for the years. Especially as the input data changes over time.

Much appreciated !!

 

[KRice]

I'm not quite sure what you have in mind or what the timeline looks like for your data, but here is an idea that dynamically adjusts the x and y ranges:

MrExcel_20220803.xlsx
	A	B	C	D	E	F	G	H	I	J
2	x vals -->	1	2	3	4	5	6	7		Projection at x=6
3	row1	2	2.75	3.25	5.5	6.75				9.368192
4	row2	3.25	4.25	6.35	7.5					14.02485
Sheet1

Cell Formulas
Range	Formula
J3:J4	J3	=GROWTH($B3:INDEX($B3:$H3,COUNT($B3:$H3)),$B$2:INDEX($B$2:$H$2,COUNT($B3:$H3)),6)

 

[BSALV]

hello and welcome.
I don't understand your example, the first number is the start, the others are periods in the future ?