Combine Age Form 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.

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.

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.

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).

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.

Calculate age Data=(YEAR(NOW())-YEAR(A2))The result is the age of personthe difference between today and the birthdate in A2. This example uses the YEAR and NOW functions. If this cell doesn't display a number, ensure that it is formatted as a number or General. Learn how to format a cell as a number or date.15 more rows

The formula, we have used to group ages in range with the Excel VLOOKUP function is: =VLOOKUP(D5,$G$5:$H$9,2,1)