ExcelBanter - I want to consoidate a list of multiples to a list of singles

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to consoidate a list of multiples to a list of singles (https://www.excelbanter.com/excel-worksheet-functions/95163-i-want-consoidate-list-multiples-list-singles.html)

Mr. Yanni

I want to consoidate a list of multiples to a list of singles

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.

Ardus Petus

I want to consoidate a list of multiples to a list of singles

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.

All times are GMT +1. The time now is 12:46 AM.