View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
campare 2 columns of numbers-find unique campare 2 columns of numbers-find unique is offline
external usenet poster
 
Posts: 1
Default find and delete duplicate entries in two columns or find and prin.

i have a set of inventory numbers that copy to an excel spreadsheet daily and
compare to yesterdays to see what had been dropped. how to i write a macro to
compare the two columns and give me only new entys in second column that have
no match in first column?