+ Reply to Thread
Results 1 to 4 of 4

removing duplicates feature is malfunctioning

  1. #1
    Registered User
    Join Date
    03-13-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    27

    Question removing duplicates feature is malfunctioning

    hi,

    my name is ian and i'm new the forum. i use excel 2007.

    i'm trying to remove duplicates from a worksheet containing customer contact info. the sheet has 9 columns with headings, and the duplicates appear in the last name and phone number column. (the sheet contains no outlines/groups/subtotals.)

    i want to remove entries that contain the same last name AND phone number, however when i go to DATA>DATA TOOLS>REMOVE DUPLICATES, and specify the columns i want to remove duplicates from, it keeps deleting an entry that has the same last name, but not the same phone number.

    i even tried removing duplicates from only the phone number column, and it still removes the phone number for the entry that has a duplicated last name, even though the phone numbers are different.

    please help.

    thanks very much!
    Last edited by Ron Coderre; 03-19-2009 at 05:32 PM. Reason: Marked SOLVED per OP request

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251

    Re: removing duplicates feature is malfunctioning

    I tried to recreate your problem but I canīt.

    Have you selected both columns before you press "OK" in the "Remove duplicates" window?

    Can you post a workbook without sensitive data? So I can recreate the problem?

  3. #3
    Registered User
    Join Date
    03-13-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: removing duplicates feature is malfunctioning

    hi steve,

    i've attached the file. thanks for taking a look.


    best,

    ian
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-13-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2010
    Posts
    27

    Lightbulb Re: removing duplicates feature is malfunctioning

    nevermind! i'm doing practice exercise files because i'm studying to become a MCAS, and i'm going back and checking all my work.

    the reason why i thought unnecessary deletions were being made is because i didn't sort the worksheet before removing duplicates and then going back and checking my work.

    sorry, everyone. i feel pretty silly. oh well.


    best,

    ian

+ 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