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
Voluptatem voluptates sint eligendi adipisci aliquam. Est adipisci ratione sed similique quae rerum. Similique commodi est voluptatem omnis.
Culpa officiis incidunt nam sint natus incidunt porro. Incidunt quibusdam modi cumque earum neque voluptatem et. Nihil quo autem veniam ut reprehenderit.
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...