Forum Discussion
levicnhotmailcom
Sep 15, 2021Copper Contributor
Using Excel to create count number report
I use Excel 2007 on Windows 10. I have a database of employee pay for 12 months. I am trying to produce a report showing how many employees were paid each month.
Riny_van_Eekelen
Sep 16, 2021Platinum Contributor
Glad I could help
levicnhotmailcom
Sep 20, 2021Copper Contributor
I ran into a glitch while trying to re-create your solution to the count problem with the Pivot table. How you linked the sum of values to the Names, and how you created the months of the year. Everything I did mirrored your output.