| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding duplicates in 2 worksheets
I have 2 worksheets of data for a mailing list I'm doing. The first worksheet has criteria pulled from one set of software and the other is from a separate system. What I want to do is find which account numbers from Sheet 2 appear on Sheet 1. Those that match get deleted from both Sheet 1 and 2 put into a new worksheeet (Sheet 3), leaving me with no duplicates in Sheet 1, and whatever is left in Sheet 2 is discarded. I'll then use Sheet 1 for one mailing, and Sheet 3 for the other. Any ideas? -- darkwood ------------------------------------------------------------------------ darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948 View this thread: http://www.excelforum.com/showthread...hreadid=541624 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help finding and summing across worksheets | Excel Worksheet Functions | |||
| excel duplicates on 2 worksheets | Excel Discussion (Misc queries) | |||
| Finding Data in multiple worksheets | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Threaded Mode
