I have an excel addin, and I use this formula, what I would like to do is set the cell reference to a variable, that would look at the cell number and then do the array
=TRANSPOSE(GaussianKernelSmoothing($A2:$A910,E1))
to
=TRANSPOSE(GaussianKernelSmoothing($A2:$A(cell lookup A1),E1))
so it would then be a variable on whatever number was in cell A1
This is an array so I hope wont produce a problem
Neil
=TRANSPOSE(GaussianKernelSmoothing($A2:$A910,E1))
to
=TRANSPOSE(GaussianKernelSmoothing($A2:$A(cell lookup A1),E1))
so it would then be a variable on whatever number was in cell A1
This is an array so I hope wont produce a problem
Neil
Last edited: