Quote Originally Posted by Charlize
I know that, but if he dont wants to use an array, he will have to create his own MaxIf and MinIf.
Thank you all for all the responses; I was away and could not respond any of the post; sorry for that.

Charlize, thank you for the idea; wondering if you can help me build Maxif and MinIf function in VBa?

thanks again...