Identifying Duplicates in Columns
 

i have 2 rows of data and I want to be sure that only uniques values are in
each column ie that a number in column A is not in column B also.
I've looked at Conditional Formatting but can't seem to get a formula that
doesn't error on me.

Identifying Duplicates in Columns
 

Take a look he

http://cpearson.com/excel/duplicat.htm

In article ,
DamienO wrote:

i have 2 rows of data and I want to be sure that only uniques values are in
each column ie that a number in column A is not in column B also.
I've looked at Conditional Formatting but can't seem to get a formula that
doesn't error on me.

How do you want the results displayed? One way to do it is to have a third column that uses the vlookup feature.

Vlookup is good because it finds exact matches.

=if(iserror(vlookup(A2,yourrange,1,false)),"OK","D uplicate")