Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting peoples' ages in age groups...?
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. -- sherry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting peoples' ages in age groups...?
sherry wrote:
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. Hi sherry, In a new worksheet (say, Sheet2) create a table like this using columns A and B: 0 <30 30 30-39 40 40-49 50 50-59 60 60+ Then, if your list of people's ages is in Sheet1 column A, place this formula in B1 and fill down: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,TRUE) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting peoples' ages in age groups...?
THANK YOU SO SO MUCH. By reading your formula, I'm assuming that I can also
use that for putting people into salary groups also. It just depends on what I choose to type in Columns A & B on Sheet 2, correct? If so, this is (and you are) a lifesaver! -- sherry "sherry" wrote: 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. -- sherry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting peoples' ages in age groups...?
sherry wrote:
THANK YOU SO SO MUCH. By reading your formula, I'm assuming that I can also use that for putting people into salary groups also. It just depends on what I choose to type in Columns A & B on Sheet 2, correct? If so, this is (and you are) a lifesaver! Yes that will work the same way. Just make sure Sheet2 column A is sorted ascending, and adjust the formula to accommodate the number of rows you have in Sheet2. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting peoples' ages in age groups...?
Got it! thx
-- sherry "sherry" wrote: 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. -- sherry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it wise to put pdf pics next to peoples names on spreadsheet? | Excel Discussion (Misc queries) | |||
Macro not working on other peoples computers | Excel Discussion (Misc queries) | |||
How can I change a list of phone numbers into peoples names | New Users to Excel | |||
formula for putting points into groups | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |