Create a formula to rearrange different values in groups

  • Thread starter Thread starter Raymond L
  • Start date Start date
R

Raymond L

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.
 
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
 
Back
Top