Function for grouping range of data
Hi all,
Trying to group data of a bunch of kids going to lessons by age group, say I've got data as follows, left column being the name of the kids and right column actual age: Kid 1 09 Kid 2 17 Kid 3 26 Kid 4 23 Kid 5 38 Kid 6 33 Kid 7 18 Kid 8 15 Kid 9 18 Is there a worksheet function to show in the next column as age group, i.e. 00-10 11-20 21-31 etc -- Thanks, Marko |
Function for grouping range of data
Somewhere, you need to define a table (I usually have a whole separate tab
for Tables, just makes it easier). Your table would be set up something like this: 0.......'00-10 11.....'11-20 21.....'21-31 32.....'32-42 43.....'43+ I use the apostrophe to ensure Excel doesn't try to autoformat it. I defined my table (Insert--Name--Define) as TblAge. then, in the column next to the age (my example, cell C2, as column B has the ages), type the following formula, and copy down as needed: =VLOOKUP(B2,TblAge,2,TRUE) Hope this helps. -- John C "supersonikk" wrote: Hi all, Trying to group data of a bunch of kids going to lessons by age group, say I've got data as follows, left column being the name of the kids and right column actual age: Kid 1 09 Kid 2 17 Kid 3 26 Kid 4 23 Kid 5 38 Kid 6 33 Kid 7 18 Kid 8 15 Kid 9 18 Is there a worksheet function to show in the next column as age group, i.e. 00-10 11-20 21-31 etc -- Thanks, Marko |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com