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,