Hi all,
I've been racking my brain for a few weeks with a spreadsheet I am working on for the world cup.
I am trying to create a lookup for a sheet which tracks statistics of players entered into a template sheet which I have created to record match results during the world cup. There will be 64 of these template sheets, 1 for each world cup match.
Everything currently works but I am using INDIRECT and SUMPRODUCTS functions (of which there are 100s of) which seem to really slow down the spreadsheet to the point it crashes regularly.
Does anyone know how I could make this spreadsheet less resource intensive?
I have linked the spreadsheet here. The main formula is all on the squads sheet and the templates are the M1, M2 etc sheets.
Most columns are hidden in order to keep the spreadsheet tidy.
Any help would be greatly appreciated
https://drive.google.com/file/d/1B-5Tw_2Z05yyloLtyXdWn442_DAJCh9b/view?usp=sharing
I've been racking my brain for a few weeks with a spreadsheet I am working on for the world cup.
I am trying to create a lookup for a sheet which tracks statistics of players entered into a template sheet which I have created to record match results during the world cup. There will be 64 of these template sheets, 1 for each world cup match.
Everything currently works but I am using INDIRECT and SUMPRODUCTS functions (of which there are 100s of) which seem to really slow down the spreadsheet to the point it crashes regularly.
Does anyone know how I could make this spreadsheet less resource intensive?
I have linked the spreadsheet here. The main formula is all on the squads sheet and the templates are the M1, M2 etc sheets.
Most columns are hidden in order to keep the spreadsheet tidy.
Any help would be greatly appreciated
https://drive.google.com/file/d/1B-5Tw_2Z05yyloLtyXdWn442_DAJCh9b/view?usp=sharing