Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function on a range of Data | Excel Worksheet Functions | |||
Aged Debt - grouping values by date range | Excel Discussion (Misc queries) | |||
Grouping a range in pivot without standard to from | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions | |||
return range of data from lookup function | Excel Worksheet Functions |