Thread: finding duplicate addresses across 2 worksheets in the same workbo
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
day day is offline
external usenet poster
  
Posts: 4
Default finding duplicate addresses across 2 worksheets in the same workbo
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?
Reply With QuoteReply With Quote