find and replace

[Karen]

I have 3,400 numbers in Col A

I have 23,000 numbers in col B

I need to delete any duplicates From col B


Thanks in advance Karen

 

[Mike H]

Karen,

Your question isn't clear, which is it:-

Delete duplicate numbers in Column B?
Delete numbers in Column B that are also in Column A?

Mike

 

[Karen]

The number in Col A is a banned section and needs the same number from Col A
if appears in Col B to be deleted from Col B



thanks

Karen