Dear Gurus,
I generally analyze data by applying formulas. However when the data I need to analyze is too big (500 columns and 60000 rows), calculating all the formulas takes excel several hours, if not days. This slows the performance of my computer dramatically and I would like to know if it is possible to have a macro run the formulas on a step wise manner and in a much more time efficient way. In the attached file you can see an example of the data and how the formulas are applied in a step wise manner. Let me know if you would like me to clarify further.
Many thanks in advance for your help,
Ale
Bookmarks