+ Reply to Thread
Results 1 to 9 of 9

Remove Duplicates Not Working!

  1. #1
    Registered User
    Join Date
    03-18-2013
    Location
    Laurel
    MS-Off Ver
    Excel 2007
    Posts
    18

    Remove Duplicates Not Working!

    Hi everyone,

    I have Excel 2007 and I am trying to remove duplicate values from my spreadsheet, but it is not working. I have a list of 800+ cases. I want to remove any rows that have the same value so there is only 1 version of the case. "Remove duplicates" keeps saying that there are no duplicates to be found, but I see them right in front of me. Any suggestions?!

    Also, I would use conditional formatting to find and then delete the rows manually, but there are way to many to do this.

    Thank you for all of your help.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Remove Duplicates Not Working!

    you could try doing a if(countif()>1,"DELETE",""), then filter based on "DELETE" and then delete what is shown?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-18-2013
    Location
    Laurel
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Remove Duplicates Not Working!

    Forgive my ignorance, but can I do that for the entire spreadsheet, or just particular columns? I did try doing it for just one cell (which I was going to drag down for the entire column), but it said I have too few arguments.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Remove Duplicates Not Working!

    It might be easier to help if you uploaded a sample workbook?

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

  5. #5
    Registered User
    Join Date
    03-18-2013
    Location
    Laurel
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Remove Duplicates Not Working!

    I've attached a sample document for your review. Essentially, I'd like to find the duplicate values and get rid of them (but leave the first one). Column A is a unique ID that will repeat for the dupes.

    Thank you so much for your help.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-24-2013
    Location
    Earth
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    81

    Re: Remove Duplicates Not Working!

    USE THIS FORMULA IN COLUMN F2 =COUNTIF(A$2:A2,A2) ,DROP DOWN
    Then you can see the result , 1 is first apprea line, >1 is other Duplicates lines
    you can use AutoFiler to choose all value 1 lines , copy to new sheet , or revert to drop other not equal value 1 lines
    It's your Call .20130324 EXCEL002.xlsx

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Remove Duplicates Not Working!

    If I select columns B:E, then goto Data>Remove Duplicates then Excel tells me 29 duplicates were removed and 39 unique values remain.

    Works if I include column A too.
    If posting code please use code tags, see here.

  8. #8
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Remove Duplicates Not Working!

    Heres a macro version. Click the button on sheet1


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mike7952; 03-24-2013 at 12:53 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  9. #9
    Registered User
    Join Date
    01-08-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Remove Duplicates Not Working!

    Hello,
    what you could do is, better provide paste special values to column A(Key 1) and then use the function " Remove duplicates" from Data option. This would remove your 21 duplicates.
    Let me know if this works out

+ 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