Thread: [Solved] Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time
View Single Post
 
Old 03-26-2016, 02:48 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Not sure if I have understood you correct, but you might want to take at look at the attached. In particular I don't know how you distinguish between Department 1, Department 2 and Department 3.

I have combined your two files into one and put some formulas in sheet Full Time Turnover by Month (and also a Pivot table).

Please note that status, FT.PT and status.Date are defined names (See Name Manager).

You can change the year in cell A3.
Attached Files
File Type: xlsx Turnover Calculation_2.xlsx (137.0 KB, 68 views)
Last edited by xor; 03-26-2016 at 06:40 AM.
Reply With Quote