On Sat, 12 Nov 2011 21:39:27 -0500, isabelle wrote:

even though, but a little shorter

=MAX(A11:A15*(B11:B15<1)*(C11:C15<1),MAX(A21:A25 *(B21:B25<1)*(C21:C25<1)))

formula array, validate with ctrl+shift+enter

Thanks for posting. Following your hint, I actually tried the even
shorter form

=MAX(A11:A15*(B11:B15<1)*(C11:C15<1),
A21:A25*(B21:B25<1)*(C21:C25<1))

as an array formula, and it worked just fine in Excel 2010. Do you
need the second MAX in an earlier version of Excel?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...