I have a worksheet that I want to go through them and remove both rows that are duplicates. The finding dups button removes only one of the dups I need both. Can anyone help me out? using Excel 2010 VBA or a neat little trick