Have a look on this starter help, taking 2 cols for Duplication check and show cases on how to retrieve all Dups, Non Dups and first from Dups:
FindDupsUniquesFirstFromGroup_By2Cols.xaml (12.4 KB)
so we would recommend:
use first from dups approach for the other Worksheet
use non dups for the duplicate removal