Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Data in Excel 2003
I have an excel file with two columns of data. I would like to Combine data
from the two columns into one column with no duplicate values. Each column contains unique values, but some are duplicated between columns. I know I can use the concatenate function but I cant figure out how to get rid of the duplicate data between columns. I tried the advanced filter but that looks at the data from each column individually and not between columns. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Excel 2007 to Excel 2003 (Split data to sheets) | Excel Discussion (Misc queries) | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
Excel 2003 Unwanted Data Labels | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) |