How do I copy an array formula?

[cguen]

Having created an array formula in one column, I would like to copy it to
adjacents columns. I would like to "freeze" the values in one column while
allowing the values in the second column to change as I copy the column
(relative cell addresses). I am using Excel 2003.

Thanks.

 

[Franz Verga]

Having created an array formula in one column, I would like to copy
it to adjacents columns. I would like to "freeze" the values in one
column while allowing the values in the second column to change as I
copy the column (relative cell addresses). I am using Excel 2003.

Thanks.

You have to use absolute references for the column to "freeze". If you would
post the formula maybe we could help better...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy