that_one_girl
New Member
- Joined
- Mar 22, 2017
- Messages
- 43
I have a worksheet that searches for staff name, thenpopulates their information from a reference sheet. Then there are trainingclasses listed, and the second formula searches for their name in a trainingrecords table, and if their name and that class title is found, it populates ascompleted.
What I need to do is
What I need to do is
- Look for the staff name (column A)
- Look to see if that staff has completed 2 courses (Column J and Column K, L or M)
- If they have both J and one of the other 3, then look at their hire date.
- Total the number of people hired from 10/1/17-9/30/18
- Divide the number of people that were hired meet the requirements in step 3 and were hired between 10/1/17-9/30/18 to give me a percentage.
- There were 19 people with hire dates between 10/1/17 and 9/30/18
- MANZO, B (column A) was hired 10/2/17 (column H), COMPLETED Orientation to Enforcement (column J) and COMPLETED Introduction to Safety (column K). Count as 1
- (in row 222 of the attached) GIER, L (column A) was hired 10/16/17 (column H), COMPLETED Orientation to Enforcement (column J) and COMPLETED Introduction to Safety (column K). Count as 1
- Divide 2/19*100 = 10.5% COMPLETED REQUIRED TRAINING to populate in cell C2