Use formulas for array elements

H

hmm

I want to make a matrix calculation using an array that is not a range of
cells, but contains formulas. For example, it could be {1; A1; A1^2}, except
that only constants can be placed in array brackets.

Is there a way of entering such an array, without using a range of cells to
enter the formulas?
 
R

Ron Rosenfeld

I want to make a matrix calculation using an array that is not a range of
cells, but contains formulas. For example, it could be {1; A1; A1^2}, except
that only constants can be placed in array brackets.

Is there a way of entering such an array, without using a range of cells to
enter the formulas?
Click to expand...

You cannot do it with an array constant in Excel. However, you could write a
user-defined function using VBA to do something like this.
--ron
 
M

MartinW

Hi hmm,

Sounds like you are asking how to cross the river
rather than explaining the entire journey. It may be
that you don't need to cross that river.

Please give more precise details about what
you are trying to achieve.

HTH
Martin
 
Top