Removing unwanted data in a column
 

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!
--
thanks,
Nate

Removing unwanted data in a column
 

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
--
AP

"nate2345" a écrit dans le message de
news: ...
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!
--
thanks,
Nate