The only thing that I know will help is if you can find a way to break
the formula up into two parts. I had an array function once and it took
ENTIRELY too long to recalculate the cells and someone helped me out
with it. They gave me two different formulas; one array and one
non-array. The way he had given this to me cut the time to recalculate
literally in half!

I'm having a little trouble following what you wrote (sorry, I'm just
tired). Could you upload an example of some sort?


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=393436