Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a formula to rearrange different values in groups
In my excel spread sheet column K, named Age, contains different values
(years) for different residences. These values range from NEW (less than a year) to 100 years old. I want to arrange, in a new column, these values in 3 groups. Those ranging from 47 to 100 will be named 1. Those ranging from 30 to 46 will be named 2. Those ranging from NEW to 29 will be named 3. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a formula to rearrange different values in groups
Assuming Age data is running in K2 down
Place in say, L2: =IF(K2="","",IF(K2="New",3,VLOOKUP(K2,{0,3;30,2;47 ,1},2))) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Raymond L" wrote: In my excel spread sheet column K, named Age, contains different values (years) for different residences. These values range from NEW (less than a year) to 100 years old. I want to arrange, in a new column, these values in 3 groups. Those ranging from 47 to 100 will be named 1. Those ranging from 30 to 46 will be named 2. Those ranging from NEW to 29 will be named 3. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a formula to rearrange different values in groups
hi
see if this will work for you. =IF(A2="","",IF(A247,1,IF(A230,2,3))) regards FSt1 "Raymond L" wrote: In my excel spread sheet column K, named Age, contains different values (years) for different residences. These values range from NEW (less than a year) to 100 years old. I want to arrange, in a new column, these values in 3 groups. Those ranging from 47 to 100 will be named 1. Those ranging from 30 to 46 will be named 2. Those ranging from NEW to 29 will be named 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unique values within groups | Excel Worksheet Functions | |||
how to create sub-groups within a main group | Excel Discussion (Misc queries) | |||
help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
find the max values for cells in consecutive groups of 600 | Excel Discussion (Misc queries) | |||
Rearrange a formula | Charts and Charting in Excel |