I like JE's better

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
try this as an array formula which means you must enter with
ctrl+shift+enter

=MAX(MAX(IF(A2:A223,A2:A22)),MAX(IF(B2:B2225,B2: B22)))

--
Don Guillett
SalesAid Software

"Tom Hollies via OfficeKB.com" wrote in message
...
Hi,

Hi,
I wonder if anyone can help, I have 2 columns say C2:C40 and D2:D40 and
I
need to add a function to say D50 that will return the Max for both
columns
provided the number is 3 in column C and 25 in column D.
Any Ideas regards Tom

--
Message posted via http://www.officekb.com