SOLVED

Grouping Value Input

New Contributor

Hi,

I have a list customers who are in different age groups. The age groups are <25, 26-35, 36-45, 46-55 and >55

If 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. 

andyk1010_0-1669346671316.png

 



2 Replies
best response confirmed by andyk1010 (New Contributor)
Solution

@andyk1010 Use IFS() function

=IFS(A2<=25,"<25 Y",AND(A2>=26,A2<=35),"26-35 Y",AND(A2>=36,A2<45),"36-45 Y",AND(A2>46,A2<=55),"46-55 Y",A2>55,">55 Y")

Harun24HR_0-1669348341229.png

 

 

Thanks so much for your assistance