Printing Unique Records

[Shaolin]

Let's say that column A has 1000 names, but many of them are repeats, how can I print out unique names (eliminate any repeats) in column B?

[Bob Phillips]

Look at Data>Filter>Advanced Filter. That has a uniques option.