Forum Discussion
Solved
Find Start and End Date for Salaries in Pivot Table
I created a pivot table of salaries of employees. I use this pivot table to find when the employee started and possibly ended. I need to only count an employee when he or she was actively employ...
As variant you may generate in parallel one more PivotTable with months aggregating them with min, max and count
To count the number of months, enter =COUNTIF(I3:T3,">0") in U3 and fill down.
- Thank you so much!
