Thread: I want to consoidate a list of multiples to a list of singles
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. Yanni
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote