View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
 
Posts: 132
Default compare two columns and pull out differences

I have two columns of numbers. I want to know the numbers that do not have a
match or are not in both columns. But I need all of each column to be
compared to all of the other column...not cell by cell. It would be great if
I could pull out the differences and put them in a different column. Looking
at two long lists of numbers to pull out the different number is very time
consuming! Thanks for any help you can give me!