So I got yesterday so great advice about look ups giving me poor performance.
All together it were 16 columns with formulas for 1000.000 + lines!
Biggest lag was the formula I got help with yesterday.
Now the calculation part takes (only) 1,2 minutes.
But....I noticed that there is still 1 formula in there which take 0,9 minutes!
So if I also could reduced that one that would be great.
This lookup is looking up a value in a pivot table.
In attached book I got a sample but be ware I have not the pivot in only as values.
All this because otherwise I will not fit under 1MB excelbook limit.
Therefore also a lot of lines have been deleted and column F and O are empty but need to be filled for the formula.
I hope somebody has a good idea to speed up this lookup and reduce my overal processing time significantly.
Bookmarks