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.