You can group by text or numbers. For example, you can group all your sales by sales region or division, or group your data by numbers such as Division 1 to 8.
You could group data by a specified range or percentage as well. For example, you can group them by age range - e.g. anyone from 1 to 10, 11 to 20, 21 to 30, etc.
Example on how to group numbers in an Excel pivot tableIn the example below, there is a list of participants, all aged between 20 and 60. Their age has been calculated from the DOB of the person and the current date. This was done using DATEDIF function.
We now want to group them by age range so it gives us the frequency of particular age ranges from the lowest to the highest.
First of all, insert a Pivot table as normal against this data and add the 'Age' field to the Row section. This will give you the full age range here, for example from 20 to 60 years.
Click on a single year entry and use the menu to select the 'Group Field' or 'Group Selection' option on the PivotTable Options/Analyse tab (depending on your version of Excel).
Here we see the grouping options below with an interval range of 10. Click OK.
Now you can add the age field again, to the value section, plus any other relevant fields. The thing to remember is that you are adding the Age field twice to the pivot table. Once to the Rows field and one to the Values.