Combining Data in Excel 2003

[Guest]

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,

 

[Guest]

You could combine the two columns and then run the Advanced Filter's extract
unique records tool. Also check this out:
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

Dave

 

[Guest]

I cant combine the data because the duplicate exist within two columns and in
different cells. for example: Column A may have the number 13191 and the
same number may exist in column B but in a completely different cell.

Any other suggestions

 

[Guest]

Assuming your data is in Col a and b starting with row a2

in column c use =A2&B2
in column d use =if(countif($c:$2:d2,d2)>1,"d","u")

apply auto filter in all columns

select "d" from customs filter and DELETE these rows.