Thread: COMBINE COLUMNS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default COMBINE COLUMNS

Combine the two columns into a new column, on a separate worksheet.

Go to Data--Advanced Filter and sort for unique records. See here for more
info: http://www.contextures.com/xladvfilter01.html#FilterUR

Dave
--
Brevity is the soul of wit.


"Johnny" wrote:

How do I combine two columns (of items numbers) without having any
duplications on another worksheet?