Show other two cell's result in one cell

Topic Labels: Sync
413 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0