Use DataAdvanced Filter. Tick Unique values option.

HTH
--
AP

"Mr. Yanni" a écrit dans le message de
news: ...
I have a column that looks like this;
Direct Mail-Ltr
Direct Mail-Ltr
Direct Mail-Ltr
Direct Mail-PC
Radio
Radio
Magazine
Magazine
Magazine
Newspaper
I would like to create a list from this column that looks like this;
Direct Mail-Ltr
Direct Mail-PC
Radio
Magazine
Newspaper
I've racked my brain on this to no avail. Any help would be of great use.