Identifying Duplicates in Columns

[DamienO]

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.

[JE McGimpsey]

Take a look here:

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

In article <[email protected]>,
DamienO <[email protected]> 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.

[Gerry-W]

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","Duplicate")


--
Gerry-W