Hi,

Try this =max(if((rangeB=37),rangeA))

Alternatively, you may also read up on the DMAX() formula in Excel's Help
menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RobFJ" wrote in message
...
I want to report the maximum number in column A, providing a condition in
column B is satisfied. All data in rows A and B are integers..

eg Max for 37 in the following table would be 65

Col A Col B

23 37
122 32
65 37


Can SKS help with the syntax

TIA

Rob