sure that will be easy enough to do give me 2 seconds i will rustle up some code for you.

create a spread sheet

in col c (paste your column a data)
in col e (paste your column b data) (start in the same row as col c)

in col b paste this formula

=IF(ISERROR(MATCH(C5,$E$5:$E$37,0)),"","X")

edit the E$5:$E$37 section to the col e data size for example if your starting at row 1 and end at row 12345 edit those numbers

drag that formula to the bottom the data in col c

all of the cells in col b with an X are duplicates of col e

you can now copy n paste special all of that page / take column e and cut it and paste to the bottom of col c

sort cols b and c together to place the X at the top then delete those rows and what you have left is what you asked for

a long winded way but easiest way besides me doing it.

Thanks for the help - sadly i just can't get it to work properly - the x's are appearing by the side of sites that aren't duplicates.

I don't think you need any fancy formulas, just a little procedural logic.

open sheet A. scroll to the bottom and create a new row with ############# (just to show where sheet A ends)

import sheet B below sheet A

use excel remove duplicates tool

now manually delete all of sheet B rows (below the ###########)

now import B again. all the duplicate values from A are gone and all the correct values from B are present.


wasn't that fun?
give me "thanks" if it worked.