View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nate2345
 
Posts: n/a
Default 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