Ranges for age group
Hi,
I need a help in excel. Am trying to group set of students based on their age group. student A's age is 14 then the 3rd col shd reflect age group between 11-20, if Student b's age is 32, the age group shd reflect as "31-40"; like wise i want to group the age in a bracket of 10 ;
could you please advice what function shd i use?
thanks
Kavitha
Try something like this:
=LOOKUP(A14,{1,11,21,31,41,51,61,71},{"1-10","11-20","21-30","31-40","41-50","51-60","61-70","Over 70"})
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Domski,
this is just amasing
wonderful
you have made my work simpler..
I work for HR dept and i was looking for such a solution for years together now and you have given a solution to my long pending issue..
thank you so much
Cheers
Kavitha
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks