How do I... return a unique list in Excel?

Excel's filter feature can create a quick list of existing data consisting of unique items. Office expert Susan Harkins demonstrates a couple of ways to produce such a list manually and then shows an automated VBA approach that accommodates a list whose source data is likely to change.

This download is also available as a How do I... blog entry.