View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kyle.macdonald kyle.macdonald is offline
external usenet poster
 
Posts: 1
Default **finding duplicates from multiple columns and highlighting**

I have a list consisting of 2 columns that a duplicate may appear in 1 column
but if the second column has a different value it is still unique. I wish to
check this list against a second master list (containing all the info) and
find the duplicates in the first list and copy these duplicates to a second
sheet in the same document. Lists contain both numbers and letters. List is
over 10,000 rows so need to have no manual part to this.

Thanks

Kyle