Hi All,

I'd like to try and use an array formula to return the minimum temperature between two dates.

Say Column A holds a list of dates. Column B holds the temperatures for each of those dates in column A. Lets say that I want to return the minimum temperature between 10th Jan 2007 and 12th Jan 2007 with the daily temperatures being 9,10 and 11 respectively.

I used the following array formula to return the maximum temperature between two dates and it succesfully returned 11:

{=MAX( (A1:A10>=DATEVALUE("10/01/2007")) * (A1:A10<=DATEVALUE("12/01/2007")) * (B1:B10) )}

However when I try and use the MIN forumla the answer I get was 0 when it should have returned 9:

{=MIN( (A1:A10>=DATEVALUE("10/01/2007")) * (A1:A10<=DATEVALUE("12/01/2007")) * (B1:B10) )}

Am I missing something?

Brad