LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help finding non-duplicate email addresses... Greg Excel Discussion (Misc queries) 16 December 19th 07 11:51 AM
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM
finding duplicate addresses diamonds Excel Worksheet Functions 2 June 21st 06 11:40 PM
Finding duplicate records in multiple worksheets HR Guy Excel Discussion (Misc queries) 2 September 22nd 05 03:45 PM
Finding DUplicate Data set in Worksheets SAT Excel Worksheet Functions 4 September 17th 05 11:50 PM


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"