Get instant live expert help on I need help with vba or operator

I need help with a formula to determine if the person is a pilot or an operator. I have highlighted the column I am trying to formulate. So william duncan should be an operator, Shelton Fisher should be a pilot.

A permanent operator can process 16 claims per day, whereas a temporary operator can process 12 per day, and on average the company processes at least 450 claims each day. The company has 40 computer workstations. A permanent operator generates about 0.5 claims with errors each day, whereas a temporary operator averages about 1.4 defective claims per day. The company wants to limit claims with errors to 25 per day. A permanent operator is paid $64 per day, and a temporary operator is paid $42 per day. The company wants to determine the number of permanent and temporary operators to hire to minimize cost. 1. Formulate a linear programming model for this problem. List the objective function (minimize or maximize) and all model constraints. 2. Solve this model graphically. Identify the following: each constraint line, feasible solution area, x1, x2 and Z for each point, and clearly identify the optimal solution. 3. Solve the problem using MS Excels Solver -All answers must be highlighted in yellow.

I want to create a pivot table that will summarize for the total records & total time for each operator.

I WANT A FORMULA OR VBA CODE FOR THE ATTACHED SHEET

i need to create a vlookup or index match vba