| 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 |
| 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 | |||
Threaded Mode
