Speed up max if array

Hi,

This is excellent Colin,
The Pivot Table option gave me instant results, woo hoo!! Unbelievably fast!!

Great, I suspected it would be pretty fast.

Does the Pivot Table and data have to be on the same worksheet for this to work?

No, you can have the pivot table on a different sheet. I've amended the previous example and attached it to this post to show this.