Hi,

You may also try the DMAX function. Suppose the column heading is Numbers
in cell C3. Suppose data is in range C4:C11

In a C14:E14, type Numbers and in C15, type =20000. In D15, type <=29999.
In cell E15, type =DMAX(C3:C11,E14,C14:D15)
In a C17:E17, type Numbers and in C18, type <=20000. In cell E18, type
=DMAX(C3:C11,E17,C17:D18)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Khusro" wrote in message
...
I have two different series in one column i.e one starts with 10000 and
other with 20000 , I need to find the max number for each one . What
should
I do limit the range to desire series?