Let's say column A I have a list of employee names and in column B I have employee education degrees. Since some employees have multiple degrees (Associates, Bachelors, Masters, etc.) there are multiple rows per employee.
What formula do you recommend that would return the highest degree an employee has earned? For example: A1:A3 read John Doe and B1:B3 reads High School, Associate, Bachelors. The end result I want to see is just the employee name and Bachelors.