Creating ranges from a table of data

[AndrewProsser7]

Hi,

I have a spreadsheet where I have a list of ages, and would like to know if there is an easy formula for counting these in to a table of ranges?

I have a work around, but would be great if there was an simple way of doing this.

Any help would be great.

[TMS]

I'm sure there is ... but it would make life easier if you uploaded a workbook with examples of what you are working with and what your workaround is.

Regards

[TMS]

Oh, and one option to consider is a pivot table though they're not one of my strong points :-)