Slow Excel File
I am working on a model which requires a significant number of INDEXMATCH functions (~200k), which is resulting in very slow excel performance. Does anyone have any tips or alternative functions that may be able to increase the files performance and time it takes to open?
Thanks!!
Index match is already one of the faster formulas in excel. I would say since your file is so large that it should probably just be done in Python or something. 200k is wild
200K index matches is insane lmao
Delete hidden defined names if applicable
Nulla totam exercitationem quidem laborum omnis cum blanditiis aut. Velit culpa quia saepe. Enim dolores sunt facere quo sunt ab ea cupiditate. Sed quo eum et laborum eum. Veritatis velit atque optio rerum ipsa et. Nobis deserunt ducimus vel distinctio non magni ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...