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
Rem odit repellendus consequatur velit velit labore. Aliquam est velit iste laboriosam recusandae repudiandae. Est et totam vero.
Numquam vel id autem. Et enim sed sunt earum voluptas sapiente et. Nihil neque aliquam quia tempore.
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...