View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DRKENNE DRKENNE is offline
external usenet poster
 
Posts: 11
Default compare and move numbers

I have two columns with 1000+ numbers in them. Column 1 is the correct
column. I want to compare columns 1 and 2 and move those in #2 that don't
match or appear in #1 to a third column. End result should be #' 1 and 2
match and a third column contains #'s that were in #2 but didn't match #1.
make any sense?