Combine Age Text For Free

To group the above data age wise, follow these steps: Select the data and insert pivot table. You can use shortcut ALT>N>V for opening pivot wizard.Now drop names in values and age in rows. A dialog box for grouping will open.You have your data grouped by age with interval of 20 years.

In Excel 2003, choose Filter from the Data menu, and then choose AutoFilter. Excel will display drop-downs in the header cell for each column. Click the Age drop-down. In the resulting list, choose Number Filters and then Between (Figure C).

Group data In the PivotTable, right-click a value and select Group. In the Grouping box, select Starting at and Ending at checkboxes, and edit the values if needed. Under By, select a time period. For numerical fields, enter a number that specifies the interval for each group.

Select the aging column and periods With a cell selected in an ACL Add-In table, click the ACL Add-In tab and select Summarize > Age. Select a date column to age. Optional To omit the count or percentage for the aging periods, clear Include count or Include percentage.

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.

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.

USING YEARFRAC FUNCTION: YEARFRAC function in Excel returns a decimal value that represents fractional years between two dates. We can use this function to calculate age.