Forum Discussion
Using Excel to create count number report
Yes, I have considered updating my software version, but do not buy into subscription as a way towards achieving the goal. I prefer to buy a software and use it the best way I see fit. The current subscription method by Microsoft has forced many people I may say, including myself to continue using old non-supported software.
You did a marvelous job creating those result. I wished I had the updated software to recreate it. Thanks for the superlative effort.
Inspired by the solution offered by @Riny_van_Eekelen, and totally building off his initial results, I created the attached sheet, showing how his initial pivot table (which you can readily create with last year's or the current partial year's actual data) can be used to answer two questions:
- your original question "How many employees were paid each month?"
- but also, "How many months of the year did each employee work?"
In both cases, it's just a matter of counting the number of cells in the Pivot Table that were filled with a number.
- Doing that vertically tells you how many employees;
- Doing it horizontally tells you, for each employee, the number of months.