Based on Age specify Categorised into Age Range

Question

Hello,

I hope this is simple one that I would like some help on, please.

I have a column where I have already calculated the age of my customer based on DoB etc. However, I would now like to place them into a specific Age Range, eg.see image below

Much thanks in advanced

PamG · Answer

Hello @JosephSerpis

Thank so much for coming back to us. This worked a charm and helped me a great deal.

Thanks and have a good evening.

JosephSerpis · Answer

Hi @PamG you would need to use a condtional formula to achieve your desired results. I mocked up an approach showcasing this.

Age_Range_30072023.yxmd