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

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