I forget how to do this and have to look it up frequently!
The key is to open the Advanced Filter Dialog, then click the option for "Unique Records Only", select "Copy to another location", and then figure out how to enter the ranges for the source and target areas of the spreadsheet. In Excel 2010 Advanced is an option for Filter over on the Data tab.
Interestingly, I just noticed that a few spaces over on the Data tab, there's an option for "Remove Duplicates" which looks like it would do the same thing. I should try that sometime.
Here's a link with the top hint:
http://www.mrexcel.com/forum/excel-questions/1684-copy-column-paste-only-unique-values.html
