I have a large workbook with a base data set of thousands of rows and hundred columns. I have some complex calculations to peform for each of these.

The calculations are dependent upon selections made by the end user.

I'm using combinations of CHOOSE, INDEX, MATCH, IF, SUMIFS, IFERROR and so on.

I have dynamic named ranges since I have tried to use Tables as appropriate and other constants/selections are Named Ranges.

The input dataset is large so I need to be mindful of the size of the file after all the calculations are complete. The workbook needs to retain all the calculations so the user can select required options and run the calculations themselves.

Should I have long calculations in a single cell for each row where I test the conditions and do the calculations in a single step or should I split them across several columns to build progressively to a single output? Speed of calculation is important.

Thanks!