Hello all - this is my first post so please be gentle as what I am going to ask is probably very basic for all you experts on here! I don't use excel much but have been asked to extract some data to show a summary on a new worksheet.
An extract of my data source is below and I want to create a new worksheet that can summarise the data, as per second table below. What is the easiest way of doing this and will this enable the summary table to be updated as/when the data source changes?
The spreadsheet records a list of children starting a particular work programme and I want to be able to summarise on a new worksheet, how many children each month started and what their Year group and gender is.
I hope this makes some sort of sense!?
An extract of my data source is below and I want to create a new worksheet that can summarise the data, as per second table below. What is the easiest way of doing this and will this enable the summary table to be updated as/when the data source changes?
The spreadsheet records a list of children starting a particular work programme and I want to be able to summarise on a new worksheet, how many children each month started and what their Year group and gender is.
I hope this makes some sort of sense!?
Year group | Gender | Start date |
11 | M | 06/07/2022 |
4 | M | 18/06/2022 |
3 | F | 14/03/2022 |
7 | F | 18/11/2022 |
5 | F | 17/01/2022 |
5 | F | 14/03/2022 |
8 | M | 04/10/2017 |
9 | M | 04/10/2017 |
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Male | Female | |
September | ||||||||||||||
October | ||||||||||||||
November | ||||||||||||||
December | ||||||||||||||
January | ||||||||||||||
February | ||||||||||||||
March | ||||||||||||||
April | ||||||||||||||
May | ||||||||||||||
June | ||||||||||||||
July | ||||||||||||||
August |