conditional max

An example?

Supposing C1:C5 contains: 1,2,3,45,23

If you array-enter* in say, D1: =MAX(IF(C1:C5<10,C1:C5))
*press CTRL+SHIFT+ENTER (instead of just ENTER)

D1 will return 3, which is the max number of all numbers less than 10 within
the range C1:C5

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brian Cornejo" wrote in message
...

--
Brian