Removing unwanted data in a column

N

nate2345

Hi Guys,

Lets say A1 - A20 were numbered 1 through 20. And B1 - B10 contained random
numbers between 1 - 20. How can I create a rule that will tell Column A to
remove any of its numbers that are found in Column B?

I appreciate your assistance!
 
A

Ardus Petus

In column C, enter:
=COUNTIF(B$1:B$10,A1)>0
and copy down

Then you can remove all numbers from column A that have TRUE in col. C

HTH
 
Top