Large spreadsheet / very slow calculation / faster computer - QUESTION

[ExcelKnut]

I'm working on a spreadsheet (Excel 2010) with 100,000 rows and over 50 columns. About 15 of those columns have formulas. It's slower than a dead yak. Is it "normal" that it takes over ten minutes to calculate? Would a better/faster computer help? My current laptop has the specs indicated below.

Processor: Intel(R) Core(TM) i5-2520M CPU @ 2.50 GHz 2.50 GHz
RAM: 4.00 GB
System Type: 64-bit OS

Any advice, suggestions etc. is greatly appreciated.

Jeff

 

[RoryA]

If you can do that, you can use MATCH with 1 as the third argument to get the relative position of the last instance of a claim number. It would be quite helpful to see a small snapshot of where and what your formulas are.

 

[SpillerBD]

=IF(A8="Total",IFERROR(Q8-J8,Q8),"")
=IF($A8<>"Total","",IFERROR(Q8+0,"no adj"))

These formulas suggest your data is a mix of data and summaries.
I argue for data on one sheet and reporting on a different sheet. A majority of reporting can be solved using Pivot Tables. Special cases are solved with SUMPRODUCTS or POWERQUERY (there's a class to take!)
But Pivot Tables and the Data Model can run tonnes faster!

 

[ExcelKnut]

Rory and SpillerBD,

I REALLY appreciate your help! I can't thank you enough. Even though I would like a new, faster computer it appears I don't need it. You guys (and this forum) are invaluable!!!

Jeff