Collate Age Permit For Free

Select the cell next to the ages you want to group, and type this formula =VLOOKUP(B2,$E$2:$F$4,2,1), (B2 is the age you use, E2:F4 is the age groups you lookup based on, 2 indicates to return the second column in the lookup range) press Enter key, then drag fill handle down to fill the formulas to cells.

Grouping by age This is easily done using the grouping feature built in to pivot tables. To group results by age, right-click any value in the Age field and choose Group from the menu.

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.

1. By Generation The Silent Generation: Born 1928-1945. Baby Boomers: Born 1946-1964. Generation X: Born 1965-1980. Millennials: Born 1981-1996. Generation Z: Born 1997-2012.

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.

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