Actually, a pivot table would have done exactly what you want.

"mebsmith" wrote:

I actually solved the problem myself, by inserting an extra column and using
the month function to generate a number value for the month then using
frequency to tally them.

Thanks

Marcus

"mebsmith" wrote:

I have data based over a number of years and i was wondering having converted
teh information dates to mm/yr format how could i get a count of the data for
each month?

...
Apr-08 COM9635 COM
May-08 TCF6498 TCF
May-08 TRS857 TRS
...

so i am just trying to count the instances in march, april, may etc...
Thanks in advance!