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.

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.

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.