+ Reply to Thread
Results 1 to 6 of 6

Remove duplicates not removing duplicates bug, so what???!!!

  1. #1
    Registered User
    Join Date
    04-11-2015
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    3

    Angry Remove duplicates not removing duplicates bug, so what???!!!

    Dear all;

    please tell me, does anybody really solve the problem of "not removing the duplicates" correctly from the time series data. Yes, I double checked no spaces and nothing wrong, I have been trying for 5 hours to solve this problem by reading all the related tips. no suggestion works with me. Please see the attached excel file and advice


    that is really annoying. please see attached. it shows no duplicates, but it is obvious, there is duplicate.

    it is on Excel 2016

    Any answer an no further questions must be appreciated. I think my question is very clear.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,646

    Re: Remove duplicates not removing duplicates bug, so what???!!!

    ...but it is obvious, there is duplicate...
    I used advanced filter to copy unique records to column C, and there is exactly the same number of records.

    Why do you think that these values do contain duplicates? Are you just basing it on the 5 decimal places that are displayed? Look in the Formula Bar and you can see that the values have up to 15 decimal places, so maybe this is confusing you.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: Remove duplicates not removing duplicates bug, so what???!!!

    Format the cells with 15 decimal places then SORT :

    You will then see the issue is one of the accuracy of floating point numbers..

    To overcome this, you will need to ROUND your data.

    If you ROUND("data",12) and then use "Remove duplicates" you will remove 406!

  4. #4
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,192

    Re: Remove duplicates not removing duplicates bug, so what???!!!

    Hi
    Your data has no duplicates.

  5. #5
    Registered User
    Join Date
    04-11-2015
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    3

    Re: Remove duplicates not removing duplicates bug, so what???!!!

    Many thanks Pete;

    you're absolutely right, but this has never happened when I was trying in past to remove the duplicates. can you please tell me how to format numbers and remove duplicates as shown (5 digits and not 15). I want to ask Excel to remove the duplicates based on the 5 digits shown and not the 15 ones.

    Best,
    Abdel

  6. #6
    Registered User
    Join Date
    04-11-2015
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    3

    Re: Remove duplicates not removing duplicates bug, so what???!!!

    many thanks to all of you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove duplicates function not removing duplicates
    By Berilium2 in forum Excel General
    Replies: 3
    Last Post: 04-01-2015, 06:55 AM
  2. Use VBA Remove Duplicates without removing cell formatting
    By Harriet.Jones in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-18-2014, 02:04 PM
  3. Remove duplicates without removing formatting?
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-28-2014, 06:48 PM
  4. [SOLVED] Removing Unused Lines After Remove Duplicates
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2013, 07:30 PM
  5. [SOLVED] Removing Unused Lines After Remove Duplicates
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2013, 04:51 PM
  6. [SOLVED] Remove Duplicates issue...Not Removing as it should
    By trosasco in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2013, 12:57 PM
  7. Remove Duplicates not removing all duplicate entries
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2008, 05:32 PM

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