Comparing two columns of data and flag any duplicates in the third column

  • Thread starter Thread starter robertguy
  • Start date Start date
R

robertguy

Hi,

Can any one help me with a Macro which will compare Data in column ‘A
with Data in column ‘B’ and if any duplicates are found in column ‘B
enter the word ‘Duplicate’ in the corresponding cell in column ‘C’. I
no duplicate is found enter the word ‘OK’ in the corresponding cell i
column ‘C’


e.g, 1234456 123456 Duplicate
1456789 198433 OK



any help who be greatly appreciated


Many Thanks


Ro
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Finding Duplicates in Multiple Columns 2
expand duplicate check to multiple columns 3
Average Duplicates in Excel 1
compare data in column A with column B to find duplicates 8
concatenate 2 columns (A2+B2) and compare for duplicates 3
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Comparing values in two columns 4

Back
Top