Hi All,
So I am using a Macro to rank 124440 firms based on a return metric, given a specific period. The Macro I wrote is as follows:
So this Macro basically ranks the firms first, then copy/pastes the values to make Excel run faster afterwards. However, the process takes forever and I have never actually finished the calculations.
Is there a way to speed things up? Would setting calculate to manual help? In that case I would have to run the copy/paste macro separately I guess.
Or is there a way to have Excel do the ranking without first inserting the formula's in each cell? This would be the preferred solution.
Well, in any case, thanks alot!
Hieronymus5
Bookmarks