Referring to an array column or row of LinEst function

**HammerTime** · 01-13-2010, 07:17 PM

Hi,

I am trying to use the LinEst function in a program. There are some good examples on the web but they all refer to a range in the format “A1:A45”. Is there a way to refer to a column in an existing array instead?

For example (thanks to Shg for this code):

Instead of:

Please Login or Register  to view this content.

Could I have

Please Login or Register  to view this content.

Where Array1 holds some data of interest.

Hope this makes sense.

**lecxe** · 01-13-2010, 07:59 PM

Hi

Not sure I understood correctly.

You mean like this?

Please Login or Register  to view this content.

**HammerTime** · 01-13-2010, 08:22 PM

Thanks that help, but I was thinking something like this:

Please Login or Register  to view this content.

Or is this not possible?

**lecxe** · 01-13-2010, 08:37 PM

If it's an array, try:

Please Login or Register  to view this content.

**shg** · 01-13-2010, 08:40 PM

You could do it like this:

Please Login or Register  to view this content.

**HammerTime** · 01-13-2010, 09:27 PM

Thanks to both of you, that is exactly what I'm after.

Shg, what does the .Transpose do? This seems to be the main difference between your solution and lecxe's.

**shg** · 01-13-2010, 11:59 PM

A single transpose converts a 2D column array to a 1D array.

You should look in the Locals window as you step through the code with and without the transpose.

Nothing will improve your coding like learning to debug.