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
 
Back
Top