Forum Discussion
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 "...
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.