MS Excel experts
Hey,,been racking my brain on this. I need a formula that will take give me a break down. Here's what I'm dealing with.
I'm keeping track of absentee's for 2 Mfg facilities. Line 1 and line 2. What I'm trying to do is to get the Excel program to count and seperate how many call offs for each plant and it's 3 shifts. Currently the spreadsheet is set up in columns. F2:F2500 is where line number 1 or 2 is entered to represent which facility. G2:G2500 is where the shift is then entered.
DATE TIME ASSOC# CONF# DEPT.# LINE Shift
I would like it to be able to give me a break down of how many call offs we get by line and shift.
Any help would be appreciated.