software

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

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

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

HTH
--
AP

quot;nate2345quot; gt; a écrit dans le message de
news: ...
gt; Hi Guys,
gt;
gt; Lets say A1 - A20 were numbered 1 through 20. And B1 - B10 contained
gt; random
gt; numbers between 1 - 20. How can I create a rule that will tell Column A to
gt; remove any of its numbers that are found in Column B?
gt;
gt; I appreciate your assistance!
gt; --
gt; thanks,
gt; Nate