finding duplicate addresses across 2 worksheets in the same workbo

  • Thread starter Thread starter DAY
  • Start date Start date
D

DAY

I have 2 spreadsheets within the same workbook that contains duplicate
addresses. I need a macro or a formula to compare all of the addresses in a
column with other addresses within that same column and the same column in
the other worksheet to pull out duplicates over both worksheets.
Any ideas?
 
Back
Top