Hello,

I have a spreadsheet with two tabs. One tab is a sheet of employee names and addresses, the other tab is a list of employee names. I want to compare list and only show what is different and hide the duplicates.

I have tried with the advanced setting under filters but it hides the unique entries and shows the duplicates. I tried with the remove duplicate function and it erases the whole thing!

Any help would be greatly appreciated and as always, thanks in advance!


- Trackmedic