ExcelBanter - duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/58764-duplicates.html)

Danbmarine

duplicates

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?

Bob Phillips

duplicates

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

and copy down

--

HTH

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

"Danbmarine" wrote in message
...
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?

All times are GMT +1. The time now is 09:59 AM.