+ Reply to Thread
Results 1 to 5 of 5

Remove duplicates does not remove all duplicates...

  1. #1
    Registered User
    Join Date
    01-30-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Remove duplicates does not remove all duplicates...

    UPDATE: TRIM removed spaces (trailing it seems) and fixed the issue. Thanks.

    Hi all,
    I have done some research on this issue but I cannot find a solution. Maybe insanity is setting in after so many hours working on this project!!

    I have a lengthy list of part numbers upon which I execute VBA (recorded macro) to remove duplicates. For some reason XL/VBA omits deleting a few of the duplicated parts.

    I have attached the sample of part numbers if you can help me solve the mystery please... I have used tools such as this one built by "shg" and have confirmed the duplicate parts have the same values in Binary.

    You will notice on Col B I set up a CountIf formula and the culprits read "2" instances in the list... and XL says n"no duplicates found" when doing a manual delete duplicates...

    What am I missing? Thank you for your help!

    M
    Attached Files Attached Files
    Last edited by TMPAPA; 06-27-2013 at 02:07 AM. Reason: Solved

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Remove duplicates does not remove all duplicates...

    CountIf = 2 , meaning there is 2 same result.
    XL says n"no duplicates found"
    , what is that meaning?
    BTW, i can't see the macro that you mention.
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Registered User
    Join Date
    01-30-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Remove duplicates does not remove all duplicates...

    Hi wenqq3,
    Thanks for the reply. I did not include the macro in the attachment as the result (whether using macro or manual process) is the same, as in, some duplicated parts do not get deleted.

    The macro line where is execute the "remove duplicates" is basically this:
    Please Login or Register  to view this content.
    I extracted the list of parts and pasted them into the sample XL file (col A) I attached. I added a "countif" column (B) to confirm whether XL is seeing these values as different or the same.

    Try doing the remove duplicates on column A of the sample (via manual / ribbon way). For me the resulting parts list still contains duplicates. I confirm this by placing a filter on col A (parts) & B (countif) and selecting all cells in col B where the value is "2".

    I have edited the sample to include the filters at the header rows. Pick col B and select all entries with value "2" to see the duplicates.

    Does this make sense? Thanks again

    M
    Attached Files Attached Files
    Last edited by TMPAPA; 06-27-2013 at 01:49 AM.

  4. #4
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Remove duplicates does not remove all duplicates...

    Please Login or Register  to view this content.
    i still can't get the exactly meaning. But i think you want remove the duplicate row.
    Macro is no fast.
    Maybe you can do the pivot table. It will only list the record without duplicate.
    Then you can just copy the list and paste to other place you want.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,009

    Re: Remove duplicates does not remove all duplicates...

    Weird ...

    It seems to work when you sort the list.

    Alternative.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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