# Dynamic range in excel

816 Reputation points
2020-10-22T07:37:21.587+00:00

Hi,
I wish to change quickly the border range of my function
=GROWTH(C14:C20,A14:A20,F2)

As input I'd pass A14 in cell E1, and then into growth function I'll get a range starting from A14 and covering 6 cells on the same column. The same about A14:20

Is it possible to do this?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,708 questions
{count} vote

1. 24,676 Reputation points Microsoft Vendor
2020-10-23T08:18:49.363+00:00

Hi @Andrea Vironda ,
Do you mean you want to fix the range of A14:A20 and C14:C20? And the dynamic parameter is F2?

If yes try this function in E1:

=GROWTH(\$C\$14:\$C\$20,\$A\$14:\$A\$20,F2)

2. 816 Reputation points
2020-10-23T10:13:30.433+00:00

Here it is!

3. 6 Reputation points
2020-10-31T13:57:09.093+00:00

Hi Andrea,

it seems to me that you need to use the INDIRECT function. If you put the range as a string in G1, and you want to pass it as the first parameter in the function GROWTH, your formula will be: "=GROWTH(INDIRECT(G1),A14:A20,F2)".
Of course you can use every kind of string as INDIRECT parameter. The formula "=GROWTH(INDIRECT("C14:C20"),A14:A20,F2)" should work as well.

I hope this is the answer you needed.

Kind regards,
Alex