|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
04-13-2008, 04:14 AM
|
#1 |
|
Member (14 bit)
Premium Member
Join Date: Jan 2002
Location: The Great NorthWest
Posts: 12,594
|
Excel duplicate records
I've searched and found ways to delete / remove duplicate records in a spread sheet, but what I need is to delete both records that make up the duplicate set.
In other words, if I have one list of: Jane Bob John Sue, and another list of: Bob Sue, All I want left is: Jane John Any ideas on how to do this? I typically deal with a master list of about 650 records, and then work with a subset that could be hundreds of records, all the way up to the master list size. What I am doing now is to copy the subset into the master list, sort, then manually delete the pairs of duplicate records. And bow-howdy is that a waste of time... TIA  TR |
|
|
|
04-19-2008, 11:03 AM
|
#2 |
|
Member (14 bit)
Premium Member
Join Date: Jan 2002
Location: The Great NorthWest
Posts: 12,594
|
any ideas?
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem With Excel Launch | Tom Jensen | Windows Legacy Support (XP and earlier) | 2 | 01-22-2008 10:51 AM |
| Duplicate Items in Excel Question | PanchoC | Software Discussion & Support | 1 | 07-10-2004 07:45 PM |
| deleting duplicate entries in Excel 2003 | okie11 | Software Discussion & Support | 3 | 06-21-2004 09:22 PM |
| Excel prob: Compile error in hidden module | calamospiza | Software Discussion & Support | 2 | 09-24-2002 04:12 AM |
| How to convert Lotus 123 to Excel? | robbsafc | Software Discussion & Support | 3 | 03-09-2002 04:31 PM |
Linear Mode
