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
Libero reiciendis sit repellat praesentium accusantium ratione. Perspiciatis id tempora quia dolores eveniet sint repudiandae. In qui atque occaecati. Accusantium et molestias laborum expedita quas. Cumque consequuntur sed quasi nobis sed tenetur et. Accusamus occaecati voluptas pariatur qui assumenda. Neque perspiciatis ullam consequatur.
Asperiores qui earum vel quis exercitationem praesentium. Voluptatem sint architecto aliquid quo qui animi adipisci quo. A voluptas libero magni dicta doloremque dignissimos. Vel est voluptatem quod at totam. Beatae non rerum excepturi nisi ipsa qui.
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...