Can faster CPU+larger/faster RAM significantly speed up recalulati
 

Need to "sumif" and "vlookup" over 10,000 records.

If not, how can I improve the calculation performance?

Many thanks.

They're both pretty hefty memory users, but we can't tell you if RAM or CPU
will significantly speed it up unless we know what you're packing now. My
guess is NO. My guess is you should get some VBA that works the formulas,
leaving the values behind.
************
Anne Troy
www.OfficeArticles.com

"jmk_li" wrote in message
...
Need to "sumif" and "vlookup" over 10,000 records.

If not, how can I improve the calculation performance?

Many thanks.

Hello,

Try http://www.decisionmodels.com/fastexcel.htm
IMHO it is worth the money.

HTH,
Bernd