News for hackers. Stuff that matters.

A comment on Accelerate Excel – 100x faster spreadsheets. Parent comment

Re:Accelerate Excel – 100x faster spreadsheets by mistermcgruff on Thursday July 31, 2014 @01:42PM (#8115697)
I make Excel choke regularly. For example, copy-pasting a complicated vlookup down 1 million rows takes forever.
[ Parent | on HN ]
Re:Accelerate Excel – 100x faster spreadsheets by bake on Thursday July 31, 2014 @03:21PM (#8116360)
Combining =index() and =match() seems to be less computationally intensive than =vlookup() -- give it a shot.

I've had entire days spent copying formulas down 5000 rows (x20-50 cols), copy, paste-values, and repeat. Can't wait to try this out, just signed up for the beta.

Another thought -- as someone who runs windows on a VM on my mac almost purely for excel purposes, this could enable me to go 100% mac. The biggest downfall to mac's excel seems to be a computation engine that's far behind the windows version.

[ Parent | on HN ]
Re:Accelerate Excel – 100x faster spreadsheets by mariocarvalho on Thursday July 31, 2014 @01:50PM (#8115755)
Why not just dump all table...?
[ Parent | on HN ]