Forum Discussion

jamesproudlock-1993's avatar
jamesproudlock-1993
Copper Contributor
Dec 14, 2018

How to autofill X amount of columns based on whatever numeric value X is

Hi,

I've been looking for a solution to the following problem since yesterday afternoon and it has me completely stumped.

I'm looking for a formula or function that will allow me to auto fill "X" amount of columns, based on whatever value "X" is.

For instance;

In the context I'm using it, it is for apprenticeship funding so:

Row 1, Columns 1 through 34 are months i.e. March 2018 through December 2020.

If Billy's apprenticeship lasts 12 months, starting May 2018, then cells May 2018 through May 2019 (12 months) auto fill with the correct formula.

Is there any way to do this?

Any help would be hugely appreciated

Regards

James

excel

1 Reply

  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Dec 14, 2018

    Hello,

     

    your formula has some differencieas through the range. However you can use below formula to add values to the required cells.

    =(COLUMN()>=MATCH($G2;$1:$1;0))*(COLUMN()<MATCH($G2;$1:$1;0)+$I2)*171

    change number 171 as required.