Extract/Summarise data onto new worksheet

Krann

New Member
Joined
Jul 6, 2023
Messages
3
Office Version
  1. 365
Platform
  1. Windows
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!?

Year groupGenderStart date
11M06/07/2022
4M18/06/2022
3F14/03/2022
7F18/11/2022
5F17/01/2022
5F14/03/2022
8M04/10/2017
9M04/10/2017

Year 0Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11MaleFemale
September
October
November
December
January
February
March
April
May
June
July
August
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Pivot table maybe
Book1
ABCDEFGHIJKLMN
1Year groupGenderStart date
211M06/07/2022
34M18/06/2022Count of GenderColumn Labels
43F14/03/2022FF TotalMM Total
57F18/11/2022Row Labels35748911
65F17/01/20222017112
75F14/03/202220221214112
88M04/10/2017Jan11
99M04/10/2017Mar112
10Jun11
11Jul11
12Nov11
13
Sheet1


1688641220710.png
1688641245418.png
 
Upvote 0
Thank you - would a pivot table automatically update if the data source changed at any time?
 
Upvote 0
Not typically you would have to Refresh it or set it up to automatically refresh on opening using some vba or setting in workbook
 
Upvote 0

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top