Find and Delete

K

Karen

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
 
M

Mike H

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
 
D

driller

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace 2
Find and delete 2
vendor matches 6
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Offset function 12
How do I split a cell into text and number 3

Top