How to remove duplicates in Excel

http://www.xlninja.com/2012/06/14/how-to-remove-duplicates-in-excel/

Problem: you have a very large set of values and you want to slim it down to only the unique values.
Solution: ‘Remove Duplicates’ function!