Finding Minimum and Maximum Values of first fifteen days

N

NIMISH

Hi All,

I have data as follows

Column A - Date (daily basis)
Column B - Qty

Column A spans more than 300 rows (dates) now.

I want to find minimum and maximum values of Qty for every date range
(1 to 15) and (16 to last date of month).

What formula should I employ?

Thanks,

Nimish
 
B

Bob Phillips

=MAX(IF(DAY(A1:A300)<=15,A1:A300))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

and

=MAX(IF(DAYA1:A300)>15,A1:A300))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top