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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel question 3
How can I add a similar amount to a full column of prices 4
Help needed with creating a Formula in Excel 2007 please ? 11
need to find value from one column in another column of the same r 3
counting Multiple answers in 1 cell + column 1
Monthly/Yearly Reporting 1
Word Letterhead templates. 3
Query showing duplicate values 2

Back
Top