Removing duplicates - Excel 2007

  • Thread starter Thread starter LMK@work
  • Start date Start date
L

LMK@work

I have two email lists - one is a subset of the other. I would like to remove
all of the email addresses from the longer list that appear in the shorter
list, leaving only the unique email addresses. I've tried using the "Remove
Duplicates" function, but it keeps telling me there are no duplicates. I'm
not sure what to try next.
 
One way is to paste the longer list below the shorter list, select the column
having the combined list and then 'remove duplicates'.. the entries left
below the short list will contain the longer list minus those which are on
the short list...

So if you have A, B, C in the short list and E,G,A,T,U,B in the long list
put E,G,A,T,U,B below A, B, C...
You will be left with A, B, C, E,G,T,U. Pick the values after A, B, C...
 
this easy to do with a way nobody know any more. it take couple steps-

1. you give name "database" to the long list you want names removed ffrom.
include the headings in the named range and all colmns.
2. do same for same list but use name "criteria".
3. put this code in vb module and run it with the sheet with data active-

Sub DataDelete()
ExecuteExcel4Macro "data.delete()"
End Sub

i try this and it still work in excel 07

|I have two email lists - one is a subset of the other. I would like to
remove
| all of the email addresses from the longer list that appear in the shorter
| list, leaving only the unique email addresses. I've tried using the
"Remove
| Duplicates" function, but it keeps telling me there are no duplicates. I'm
| not sure what to try next.
 
Back
Top