On Nov 7, 4:07*pm, Eric wrote:
Does anyone have any suggestions on how to determine the value from a list?
Under column A, there is a list of date, and under column B, there is a list
of number. I would like to determine the maximum and minimum numbers under
column B for this year 2008.
For example:
Nov-2007 * *31
Dec-2007 * *54
Jan-2008 * *10
Feb-2008 * *60
Mar-2008 * *50
Apr-2008 * *20
May-2008 * *35

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Try =MIN(IF(YEAR(A1:A7)=2008,B1:B7,FALSE)). This needs to be entered
as an array formula (ie press CTRL+SHIFT+ENTER to enter the formula).
Substitute MAX for MIN as required. Note that the MIN formula will
only work correctly if all your data values are zero or positive. If
there are negative numbers it won't work in this form and needs to be
changed.

Regards

Murray