+ Reply to Thread
Results 1 to 5 of 5

remove duplicates in column

  1. #1
    Registered User
    Join Date
    10-25-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2001
    Posts
    2

    remove duplicates in column

    In Excel 2001 on MAC OX S-I have a list of 49,000 names, most are duplicates after merging numerous mailing lists. Need to eliminate the duplicate entries and have only unique names for mailing. Finding lots of information to use the 'remove duplicates' button, but I can't find it anywhere. Where is it? And if I don't have one, how do I accomplish this task short of hand deleting line by line.

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: remove duplicates in column

    Assuming your version of Excel has the same menus as Excel 2003 for windows....

    1. highlight your column(s)
    2. got to data / filter > Advanced Filter...
    3. you can either filter the list in place or copy the list to another location
    --Choose the location if you chose the copy to another location option
    4. Check the "unique records only" box
    5. Click OK

  3. #3
    Registered User
    Join Date
    10-25-2009
    Location
    Portland, OR
    MS-Off Ver
    Excel 2001
    Posts
    2

    Re: remove duplicates in column

    Your solution does create a much shorter list. My challenge now is to get rid of all the hiding names to reduce the list from 52, 000+ to only the unique names. I tried to copy and paste to a new document which resulted in a list still at 52,000+. Under Insert>List is an option I couldn't get the desired results either. Couldn't find a 'save list as' option.
    How do I totally eliminate the duplicate records from the column?

  4. #4
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: remove duplicates in column

    I apologize if you are still looking for a solution - I missed your response posting.

    If you use the copy to another location option, you can then copy and paste that list directly.
    If you use the in place method:
    1] Highlight the list
    2] Press the Alt and ; keys at the same time. This will slect visible cells only.
    3] Copy and paste.

  5. #5
    Registered User
    Join Date
    09-17-2009
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: remove duplicates in column

    I'm sorry- I posted without thinking it thorough!

    Never mind!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1