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,