I was recently asked in a class about grouping entries together. In that case it was fish lengths but what I show here applies to a wide range of options. The first method shows you how to use the inbuilt facilities of Excel pivot tables to group numbers into consistent size “buckets”. The second method is what to use if your “buckets” – in this case age groupings are not standard.

You can download the first file here and the second file here