Group days by month ....

M

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?
 
D

Don Guillett

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