Removing Numbers in Range 1 if Not Found in Range 2

[tombo131]

Hello all,

I was hoping someone could help me with this. I have a range of numbers, non-sequential 6 digit figures in column A. In column B, I have another range of 6 digit figures.

I need to have Excel remove all numbers in column B that do not have an exact match in column A.

Thanks,
Tom

 

[tombo131]

Ok, so I was able to figure out my first question by using code from this thread: http://www.mrexcel.com/forum/showthread.php?t=577145&highlight=match+remove


This has lead me to another issue...

I have Column A and B with non sequential numbers. Columns C, D, and E need to correspond with Column B. However, I need to eliminate any numbers in Column B that do not have a match somewhere in Column A.

Any ideas?
<table style="border-collapse: collapse; width: 95pt;" width="126" border="0" cellpadding="0" cellspacing="0"><col style="width: 95pt;" width="126"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 95pt;" width="126" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> </tr> </tbody></table>