D
Dominic_gates
Hi,
I really hope someone can help me with this.
I want to know if there is a formula which can group numbers together. I
will explain further:
In my spreadsheet, column T contains 'Ages' of individuals. There is a
different entry in each row between row 3 and 391.
What I would like to do is be able to group all the people within certain
age ranges together and count the number of them that there are, so for
example group all the people together from: 18-29, 30-39, 40-49, 50-59,
60-69, 70+
This will make it a lot easier for me to search through my spreadsheet and
compile this report.
If anybody can help please get back to me.
All the best.
Dominic.
I really hope someone can help me with this.
I want to know if there is a formula which can group numbers together. I
will explain further:
In my spreadsheet, column T contains 'Ages' of individuals. There is a
different entry in each row between row 3 and 391.
What I would like to do is be able to group all the people within certain
age ranges together and count the number of them that there are, so for
example group all the people together from: 18-29, 30-39, 40-49, 50-59,
60-69, 70+
This will make it a lot easier for me to search through my spreadsheet and
compile this report.
If anybody can help please get back to me.
All the best.
Dominic.