Speed Improvement - Macro extract higher/lower values and note time differences

Donkeyote -
original thread is here: http://www.excelforum.com/excel-prog...ique-cell.html

Phil V-
Yes, when doing a full test it will be run from G2.
Yesterday I tested from cell G200 and timed it exactly for 60 seconds, and in that 60 seconds it calculated 20 (possibly 23-24) Avg/StDev/Max values.
I'll update my profile to show that I'm using Excel 2007 and conditional formatting is not important. Apologies about that.

If you guys have additional questions please let me know. Thank you for taking a look at it.