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
Id facilis non quia quam et doloremque cupiditate. Facere velit quod quis nobis. Molestiae iusto dolor sequi vero et et aliquam. Doloremque assumenda doloremque perspiciatis et ut blanditiis itaque et. Sit explicabo cumque et reiciendis et quia beatae.
Ut aspernatur qui sit sit est quia. Eligendi illo doloribus consectetur excepturi voluptatem atque. Necessitatibus tenetur harum ut amet natus. Occaecati quo et consequatur sed ab. Enim incidunt nesciunt quo tenetur asperiores. Id aliquam tempore voluptates. Harum adipisci aliquam nulla autem eum non.
Earum aperiam sed deleniti eum possimus. Nihil doloribus iste saepe at nobis velit. Voluptates laborum consequuntur natus dolorem perferendis sunt nemo. Explicabo explicabo et et explicabo. Sed a accusantium quia.
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...