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

J

jmk_li

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

If not, how can I improve the calculation performance?

Many thanks.
 
A

Anne Troy

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
 
Top