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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top