arlu has just helped uploaded the latest version & here are a few changes i thought i'll highlight:
1. Changed all the formulas which has "+0" to "--" as I've read from below that it's slightly faster. Also faster than "*1"
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
Affected are Sheet 24 & 39

2. Found some new ways to doing MIN with condition avoiding array. Realized I had another sheet with MIN/MAX with condition, so I separated the 2 & placed them side by side
Sheet 25 now consolidates the MIN with Condition. Sheet 26 is switched with 49 to make it side by side & 26 now only contains MAX with condition.