Speed - it's more than just a movie
Posted by Jill-ann Cooper on April 05, 2000 6:46 PM
I need some advice. I can go two or three different directions with a tool I'm creating and absolutely MUST pick the quickest to run.
1) I have to perform several different calculations based on the age of a store (like projected sales, etc). Is it faster to calculate the age by month in a separate matrix and then do a lookup to that matrix every time I need to use it OR is it faster to calculate the age in the same cell in which I am running the sales calculation?
2) Which is faster an array formula or a lookup?
These are very important to me because I am about to run projections for 2500 stores over 130 periods (for 15 different variables). Size is not an issue (at least this time it isn't) but speed is. Please help!