Grouping data

[Stabback]

Hi there, I have a lot of data on a spreadsheet. It is set up that for every day that something happened it records a day and then how many things happened. For example:

3/21/2003 14
3/24/2003 6
3/25/2003 4
3/28/2003 3

This spreadsheet spans from 2003 to current. My problem is I wish to present the information grouped in months. Is there a function or any way to parse the spreadsheet and return the data such as

3/2003 52
4/2003 71
5/2003 47

Thanks for your help
-Josh

[Sliderule]

Josh:

Yes, grouping data ( in your case, by year and month ) is possible within Calc.

The process involves two steps:

1. DataPilot
2. Outline - Group

In the first step ( DataPilot ):

1. Select all your data, including the column names, then from the Menu:
   
2. Data -> DataPilot -> Start...
   
3. Drag the Date Button to the Row Fields area
   
4. Drag the Item Button ( or whatever name you used in your sheet ) to the Data Fields area
   
5. Click More to determine the location you want the results in ( sheet name etc )
   
6. Press OK

In the second step ( Outline - Group ):

1. Select ANY date cell . . . press F12 ( OR from the Menu: Data -> Outline -> Group... )
   
2. In the Group By section . . . click Intervals, and, Months and Years
   
3. Press OK

The result will be what you are looking for.

I hope this helps, please be sure to let me / us know.

Sliderule

[Stabback]

Thanks, thats exactly what I wanted.