Regular Formulas vs Array... err... CSE formulas


Posted by vannie on October 03, 2001 5:08 PM

Hi! This is my first post, and I'm rather slow, so please bear with me if my question is stoopid :)

I seem to have the opposite problem everyone else does, I mean, I use those CSE formulas absolutely everywhere, like, when I have two rows, and in the next row I have to sum them up, instead of filling the row with something like: =A2+A3 till =Z2+Z3, I simply place an array formula =A2:a3+Z2:z3. Yeah, I'm weird, I know!

My question is, is this weirdness of mine costly in terms of efficiency? I'm making this HUGE spreadsheet financial model thingie, and it's starting to eat resources, I have to frequently close other windows when working on it, and I'm beginning to wonder if that's because of my CSE formula usage everywhere.

So the question which I could've asked in one simple sentence but took three whole paragraphs to ask is: Are CSE formulas more inneficcient than regular formulas, and I should try to limit their usage, or can I keep being weird and look for the solution to my resource problems elsewhere? :)

Thanks and sorry for my longwindedness


Vannie

Posted by Anon on October 03, 2001 8:47 PM

The answer is "Yes". That is, avoid array formulas if possible - too many in a worksheet makes it s.l..o...w....



Posted by Juan Pablo on October 04, 2001 7:08 AM

From an earlier discussion...

...this two links came up, they can put some lights to your trouble.

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

http://www.frontsys.com/dotprod.htm

Also, they are very good web pages with some cool tips...