# how to do median by month for daily flow data in Excel 2002?

#### MCMA

##### New Member
Been struggling with this for a bit now....

Using Excel 2002 in Win2000Pro

I have five years worth of daily river flow data. Column 1 is in dd/mm/yyyy and column 2 is numeric data. The data is not necessarily continuous - data from some days has been lost. Those missing days have been removed from the daatset.

What I'm after is the calculation of median by month for each month of those five years. I've been trying to select a range by month and have had no joy....

if only median was available in sub-totals....

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Re: how to do median by month for daily flow data in Excel 2

MCMA said:
Been struggling with this for a bit now....

Using Excel 2002 in Win2000Pro

I have five years worth of daily river flow data. Column 1 is in dd/mm/yyyy and column 2 is numeric data. The data is not necessarily continuous - data from some days has been lost. Those missing days have been removed from the daatset.

What I'm after is the calculation of median by month for each month of those five years. I've been trying to select a range by month and have had no joy....

if only median was available in sub-totals....

Let A2:B40 house the data.

Let C2 house the first day date of the month/year of interest, e.g., 1-Jan-2002.

=MEDIAN(IF(\$A\$2:\$A\$40-DAY(\$A\$2:\$A\$40)+1=C2,\$B\$2:\$B\$40))

which must be confirmed with control+shift+enter, not just with enter.

All sorted! Sirrah, my thanks to you.

Replies
3
Views
112
Replies
2
Views
274
Replies
0
Views
287
Replies
1
Views
172
Replies
4
Views
238

Threads
1,196,081
Messages
6,013,318
Members
441,760
Latest member
Sharina

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back