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!
