I tend to use a lot of extra helper columns to make things easier to understand when building up formulas... but does this unnecessarily bog down the spreadsheet and reduce its speed when recalculating?
When I've finalised everything - should I delete these extra columns and use one super complicated formula to perform all the operations in a single cell?
(Or is it the other way around... do simple calculations across many columns actually make it run faster?)
Appreciate any advice!
When I've finalised everything - should I delete these extra columns and use one super complicated formula to perform all the operations in a single cell?
(Or is it the other way around... do simple calculations across many columns actually make it run faster?)
Appreciate any advice!