Skip to main content

Hi, I have customers who create different accounts. Each account contains 1-4 members. Among these members, I want to sort their ages into different cells like “age 1-18”, “age 19-59”. “age 60+”. Not only sort them into the right group(cell) but also show ages as well. Is it possible?


For example in one account has 4 memebers, ages are" 2, 21, 63, 76", so it will show like this:

“age 1-8”: 2

“age 19-59”: 21

“age 60+”: 63, 76


how can I write a formula like this?


Thank you very much!

Be the first to reply!

Reply