The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel product group and occasional guest contributors.
Don't forget about the "A" in "VBA"!
Summary: Shows how to create a unique list of values, first by using the user interface and some formulas, and then by using VBA code in an Excel add-in.