The are 3400 numbers in Col A this is a banned section.
If an identical number appears in Col B containing 23,000 numbers

it needs to be deleted from Col B Only.
thanks

Karen

Karen,

Try this in C1

=IF(COUNTIF($A$1:$A$3400,B1)0,B1,"")

Fill down to the length of column B data range and it will give a list of
duplicated number in Column B.

Sort columns B & C together by column C descending and all the duplicates in
Column B should be at the bottom for deletion.

Mike

"Karen" wrote:

The are 3400 numbers in Col A this is a banned section.
If an identical number appears in Col B containing 23,000 numbers

it needs to be deleted from Col B Only.
thanks

Karen

hi karen,
i will try the same way with Mike with some more effort to delete the cells
containing the unwanted numbers and arrange column B as if nothing happened.
regards,
driller
--
*****
birds of the same feather flock together..



"Karen" wrote:

The are 3400 numbers in Col A this is a banned section.
If an identical number appears in Col B containing 23,000 numbers

it needs to be deleted from Col B Only.
thanks

Karen