Array formulas

[ceemo]

Hi,

I am new to aray formulas and im finding them very handy however i am finding that they slow the spreadsheet up alot and calculations now take some time to run.

Is this normal and is there anything i can do/try ?

[Peo Sjoblom]

Yes, that is the drawback of array formulas, here are some info

http://www.decisionmodels.com/calcsecrets.htm

Regards,


Peo Sjoblom

"ceemo" wrote:

>
> Hi,
>
> I am new to aray formulas and im finding them very handy however i am
> finding that they slow the spreadsheet up alot and calculations now
> take some time to run.
>
> Is this normal and is there anything i can do/try ?
>
>
> --
> ceemo
> ------------------------------------------------------------------------
> ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
> View this thread: http://www.excelforum.com/showthread...hreadid=373950
>
>