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
|