Daily Basis Personnel Grouping Based on Their Department

[hacigultekin]

I have created a personnel tracking chart and I have two different worksheets in this study, one where I keep the logs and the other is the summary sheet. I want the values on the summary page to come dynamically to different cells as department-based employee/off-duty/reported/nationality/shift according to the date I selected. I tried all combinations of polytope and if formulas. I would be very grateful if a friend who knows can help about the subject.

file download link : click