I have a large excel data file that contains a list of employees and online trainings that they have or have not completed. I need to see if there is a fairly easy way (would prefer a formula vs. VBA) to have excel search this file for the employees and which trainings they have completed and format the information into a different sheet in the workbook. The data file is exported from another program that only returns information about trainings that an employee has completed. However, we are only tracking certain trainings (i.e. an employee may have taken 50 trainings but we only want to know if they passed/failed 10 of them.

Example of Data File:

Employee Name Training Course Pass/Fail
Smith, Joe Safety 101 PASS
Smith, Joe HR Policies PASS
Smith, Joe Benefits & You PASS
Turner, Amy Safety 101 FAIL
Wilson, Helen Safety 101 PASS