Grouping Value Input

Question

Hi,I have a list customers who are in different age groups. The age groups are &lt;25, 26-35, 36-45, 46-55 and &gt;55If the customer falls into the age group a Y appears, if not the cell is blank. What I would like to do is to create a new column called age category and based on which group they fall into excel will populate that result in that column rather than having Y or blank appear in one of the 5 columns.&nbsp;&nbsp;

harun24hr · Accepted Answer

andyk1010&nbsp;Use IFS() function=IFS(A2&lt;=25,"&lt;25 Y",AND(A2&gt;=26,A2&lt;=35),"26-35 Y",AND(A2&gt;=36,A2&lt;45),"36-45 Y",AND(A2&gt;46,A2&lt;=55),"46-55 Y",A2&gt;55,"&gt;55 Y")&nbsp;&nbsp;

Forum Discussion

Grouping Value Input

2 Replies

Resources