duplicates

D

Danbmarine

I need to specifically check for duplicates between two columns:

For example:

col1 col2
12345 1102897
4794848974
8347474
493836
1102897

What formula can I use to check the data from col 2 against the data from
col 1?
 
B

Bob Phillips

=IF(COUNTIF($A:$A,B1)>0,"Duplicate","")

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top