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