Hi
I want to count the number of times someone has called per month based on their ID number.
On sheet 1 I have the data and on sheet 2 I have the summary report.
Attached is sheet 1 with the dataset and sheet 2 with the summary report and then an example of the outcome that I want on sheet 2
Sheet 1.png
Sheet 2.png
Sheet 2 - with data.png
I have tried using a pivot table but it doesn't display as I want.
The data sheet (Sheet 1) will be populated monthly and I can change the headings for the summary page for the months.
Hopefully that makes sense.
Thanks in advance.
Bookmarks