View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aubudgo aubudgo is offline
external usenet poster
 
Posts: 1
Default common numbers in 2 columns

I have two columns of numbers. One is a large list with say 3,000
random
serial numbers. The other is a smaller list of 800 serial numbers. I
want to
find if any serial numbers are listed in both of the columns. I want to
identify which number appear in both columns and move them to another
column, or at least highlight them. I tried to follow the advice given
to an earlier post but could not make it work for me: perhaps I need a
simpler or more detailed explanation.