Hi
How should I use IF or IFS function to deal with the situation below. Many thanks!
I would to assign the number "1" for the age group of 1960s, "2" for the 1970s and "3" for the 1980s.
Current data:
<tbody>
</tbody>
Proposed result:
<tbody>
</tbody>
How should I use IF or IFS function to deal with the situation below. Many thanks!
I would to assign the number "1" for the age group of 1960s, "2" for the 1970s and "3" for the 1980s.
Current data:
Date | Age Group |
1/1/1960 | |
31/12/1969 | |
1/1/1970 | |
31/12/1979 | |
1/1/1980 | |
31/12/1989 |
<tbody>
</tbody>
Proposed result:
Date | Age Group |
1/1/1960 | 1 |
31/12/1969 | 1 |
1/1/1970 | 2 |
31/12/1979 | 2 |
1/1/1980 | 3 |
31/12/1989 | 3 |
<tbody>
</tbody>