Simple sorting formula

[fredmcted]

Hi All,
My brain has gone completely blank.
I've got a table of data which id like to extract certain results according to date.
So for example multiple people used the service within January, from this id like to work out the number of adults, if they were registered, total cost, what service. The way i was going to do it was to have a complicated IF formula and 12 columns which id then extract the data from. there must be a formula I'm missing and have overlooked. I hope you can help. FredMcTed[TABLE="width: 500"]
<tbody>[TR]
[TD]service use[/TD]
[TD]age[/TD]
[TD]registered[/TD]
[TD]service[/TD]
[TD]cost[/TD]
[/TR]
[TR]
[TD]11/1/12[/TD]
[TD]21[/TD]
[TD]y[/TD]
[TD]part 1[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]14/1/12[/TD]
[TD]16[/TD]
[TD]n[/TD]
[TD]part 2[/TD]
[TD]250[/TD]
[/TR]
[TR]
[TD]12/2/12[/TD]
[TD]42[/TD]
[TD]y[/TD]
[TD]part 1[/TD]
[TD]500[/TD]
[/TR]
</tbody>[/TABLE]

 

[arthurbr]

Perhaps a Pivot Table will do the trick?