Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
performing function on selected rows
I would like to know if there is a way or function that would allow me to
look at a table and take the mean, min, max and range of supply for January. month supply January 5 Feburary 4 January 3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
performing function on selected rows
Hi Mike,
One last question, is there a formula that would work that would look for the previous month because this data is always performed on the previous month during the first week of the current month. Thanks for the help, Paul "Mike H" wrote: Hi, Yes you can do that but you would need properly formatted dates =MAX(IF(MONTH(A2:A11)=MONTH(NOW()),B2:B11)) Once again an array Mike "drose" wrote: That will work, I assume there isn't a way for it to find MAX, MIN etc for current month? so I will always need to type "month" that I'm looking for? "Mike H" wrote: Hi, I've assumed that the date column is text and not a formatted date =MAX(IF(A2:A11="January",B2:B11)) =MIN(IF(A2:A11="January",B2:B11)) =AVERAGE(IF(A2:A11="January",B2:B11)) These are array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array Mike "drose" wrote: I would like to know if there is a way or function that would allow me to look at a table and take the mean, min, max and range of supply for January. month supply January 5 Feburary 4 January 3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
performing function on selected rows | Excel Programming | |||
performing function on selected rows | Excel Programming | |||
performing function on selected rows | Excel Programming | |||
performing different calculatons on whether yes or no is selected | Excel Worksheet Functions | |||
Function to return # of column with min value in selected rows | Excel Worksheet Functions |