Removing unique values

Hello everyone   I hope someone can help me.  What I am trying to do is remove all of the unique values from a spreadsheet.  Or alternatively, remove the duplicates but for them to be saved into an...