S
sherry
Hi - I have a very long list of peoples' ages from about 22 - 70 yrs. old. I
need to put them into 5 different groups.
<30, 30-39, 40-49, 50-59, 60+>
I don't mind using more than one formula but I can't figure out how to write
it so if I highlight those cells of numbers they will grouped into those age
groups. I kind of would like to see the age group that the person falls into
maybe in the column next to their age so I can still see my original data.
Any help would be greatly appreciated. thanks much.
need to put them into 5 different groups.
<30, 30-39, 40-49, 50-59, 60+>
I don't mind using more than one formula but I can't figure out how to write
it so if I highlight those cells of numbers they will grouped into those age
groups. I kind of would like to see the age group that the person falls into
maybe in the column next to their age so I can still see my original data.
Any help would be greatly appreciated. thanks much.