Remove Duplicates and Copy to another sheet

[DDFarm]

I have a work sheet with 3 columns in each (Last Name, First Name, and Full Name). I need to be able to remove duplicates and copy the duplicate full name to another sheet.

 

[VoG]

Look here http://www.mrexcel.com/tip138.shtml