Group days by month ....

[Mikey C]

Hi folks

I have a shed-load of data that is grouped by day (eg. each date has a
corresponding number). I would like to be able to display the same data
but grouped by month and showing the daily data averaged for that month
to make it easier to analyse.

Can anybody help?

 

[Mikey C]

Sorry - would also be useful to group by week too

 

[Don Guillett]

To "display" the grouped data use data>filter>autofilter>custom>
then use the SUBTOTAL function

 

[Mikey C]

Thanks Don - appreciate it