Hi,
I heard that I can speed up my workbook by getting rid of any CSE array formulas and even changing the Vlookups to Index Match. I managed to take care of the Vlookups in Yellow and now I'm just having trouble figuring out just one Array formula highlighted in Blue. Please see attached.
This calculation page is re-calculated hundreds of times in a loop so any speed increase is helpful.
thanks
Last edited by stockgoblin42; 05-21-2013 at 04:45 PM.
live logic & long prosper
got it me self, scorp noodle
Glad to hear it. As per forum rules, would you please post the solution to make the thread complete? Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
=index(i17:i21,match(min(n17:n21),n17:n21,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
stockgoblin42 
Register To Reply
Bookmarks