Howdy,

I have a list of employee numbers and names. Sometimes the employee is on loan to another division and their serial number is imputed twice.

I want to look up an employee number and have a table populate all the unique times the employee number appears.

Thanks.

find employee with duplicates.xlsx