Max; Min & Dates
 

My spreadsheet has dates in Column A and data in columns B-S all relating to
shipments. Column P contains weights. What I am trying to do get Max & Min
for specific time frames. The Max formula
=MAX(--(MONTH(A$3:A$88)=1)*P$3:P$88) using CSE seems to work but the Min
returns blanks. Data exists in rows 3 - 30 only. I am keeping the
spreadsheet open as I add at least three shipments per week. Any suggestions?

Thanks,

Ron

Max; Min & Dates
 

The principal is shown in the attached picture.
http://img705.imageshack.us/img705/3079/nonameaw.png
*** These are array formula, and are to be confirmed with CTRL+SHIFT+ENTER
rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
€œExcel€�, when the formula is entered as an Array formula.
Micky


"ronnomad" wrote:

My spreadsheet has dates in Column A and data in columns B-S all relating to
shipments. Column P contains weights. What I am trying to do get Max & Min
for specific time frames. The Max formula
=MAX(--(MONTH(A$3:A$88)=1)*P$3:P$88) using CSE seems to work but the Min
returns blanks. Data exists in rows 3 - 30 only. I am keeping the
spreadsheet open as I add at least three shipments per week. Any suggestions?

Thanks,

Ron

Max; Min & Dates
 

The MIN Formula can also be:
{=MIN(IF((MONTH(A$1:A$25)=1)*(B$1:B$25)<0,(MONTH( A$1:A$25)=1)*(B$1:B$25)))}
Micky


"מיכ�ל (מיקי) �בידן" wrote:

The principal is shown in the attached picture.
http://img705.imageshack.us/img705/3079/nonameaw.png
*** These are array formula, and are to be confirmed with CTRL+SHIFT+ENTER
rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
€œExcel€�, when the formula is entered as an Array formula.
Micky


"ronnomad" wrote:

My spreadsheet has dates in Column A and data in columns B-S all relating to
shipments. Column P contains weights. What I am trying to do get Max & Min
for specific time frames. The Max formula
=MAX(--(MONTH(A$3:A$88)=1)*P$3:P$88) using CSE seems to work but the Min
returns blanks. Data exists in rows 3 - 30 only. I am keeping the
spreadsheet open as I add at least three shipments per week. Any suggestions?

Thanks,

Ron