View Single Post
  #1   Report Post  
genoq
 
Posts: n/a
Default What formula should I use to compare duplicate data between worksh

I have a workbook with 2 spreadsheets, each with containing a list of part
numbers. On the second spreadsheet, I want to compare lists and identify
duplicates from the first list, without changing the sorted order of either
list. What is the easiest way to flag these duplicates on sheet 2