Including a number in a formula thats from a cell reference

[Tinkerz]

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

 

[Andrew Poulsom]

What is GaussianKernelSmoothing and what is your question exactly?

 

[Richard Schollar]

The "traditional" way of doing this would be to use Indirect:

=TRANSPOSE(GaussianKernelSmoothing(INDIRECT("$A2:$A" &A1),E1))

However, given you are wrapping this within TRANSPOSE (and thus need to select the destination range to begin with) I'm not sure this will meet your needs.

 

[Tinkerz]

ok I will try and see what results I get.