find and replace
 

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

find and replace
 

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" wrote:

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

find and replace
 

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




"Mike H" wrote in message
...
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" wrote:

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