Consolidate Age Permit For Free

Pivot tables won't allow you to group dates if there are any invalid dates within the data source. Blank cells are also considered to be invalid dates, so you must make sure that there are no blanks.

The Simple Rule for Grouping Dates in Pivot Tables All cells in the date field (column) of the source data must contain dates (or blanks). If there are any cells in the date field of the source data that contain text or errors, then the group feature will NOT work.

To group ages into buckets like this, right-click any value in the Age field and choose Group from the menu. When the Grouping dialog box appears, set an interval that makes sense for your data. In this case, I'll group by 10 years. When you click OK, you'll see your data neatly grouped by age range.

You can also right-click a date field in the Rows or Columns area in the PivotTable Fields task pane. A dialog box appears. Click the date periods that you want to group by. Select Quarters, Years, Months or Days.

Grouping by Months in a Pivot Table Select any cell in the Date column in the Pivot Table. Go to Pivot Table Tools > Analyze > Group > Group Selection. In the Grouping dialogue box, select Months as well as Years. You can select more than one option by simply clicking on it. Click OK.

To group ages into buckets like this, right-click any value in the Age field and choose Group from the menu. When the Grouping dialog box appears, set an interval that makes sense for your data. In this case, I'll group by 10 years. When you click OK, you'll see your data neatly grouped by age range.

Here are the steps to do this: Select any cell in the Date column in the Pivot Table. Go to Pivot Table Tools > Analyze > Group > Group Selection. In the Grouping dialogue box, select Months as well as Years. You can select more than one option by simply clicking on it. Click OK.