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,

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/duplic...tractingUnique

Dave

--
Brevity is the soul of wit.


"Marilyn" wrote:

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,

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


"Dave F" wrote:

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/duplic...tractingUnique

Dave

--
Brevity is the soul of wit.


"Marilyn" wrote:

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,

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.


"Marilyn" wrote:

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,