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.