I am trying to remove duplicates for one column, but only if the employee name is different on an adjacent column. So a job number that is duplicated between 2+ employees would only be removed if it was a duplicate for each individual employee. Duplicates are kept if they are adjacent to different employees Example:
Capture.PNG
I am trying to calculate an average based on distinct job numbers per employee, but regular sumproduct/countif formulas to count the distinct jobs are running too slowly because of the amount of data. I am hoping to copy the original job numbers and other relevant information to a new sheet, remove the duplicates, and calculate the average based on that. Any help is greatly appreciated.
Bookmarks