Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Worksheet Functions | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to Determine 1st, 2nd & 3rd for a PWD | Excel Discussion (Misc queries) |