+ Reply to Thread
Results 1 to 4 of 4

Remove duplicates function not removing duplicates

  1. #1
    Registered User
    Join Date
    03-30-2015
    Location
    Ireland
    MS-Off Ver
    2007
    Posts
    2

    Unhappy Remove duplicates function not removing duplicates

    Hi there!

    I have a spreadsheet that I'm using to plot two time domain signals against each other. I'm still ironing out the kinks at the moment and a problem that I've encountered is that excel isn't removing dupicate time values for one of the signals.
    It's telling me that it's found duplicates deleted them and theres something like 130,000 unique values remaining, but it doesn't delete the duplicate values and instead just deletes everything after sample 130,000.

    I thought at first that because they were calculated by a formula, that would be causing a problem so I copied the values only and it still won't remove the duplicates.
    I thought then that because I have more than 32,000 values (about 440,000 values) that would be causing the issue, so I split the column up so that it had on 30,000 values and it still didn't remove the duplicates.

    It's strange because excel will remove duplicates with no problems for the smaller time domain signal that is in the spreadsheet with no problems.
    I've included the spreadsheet here (without the macro that I've been using to import the data automatically)
    https://www.dropbox.com/s/i4ygc7bxy4...Test.xlsx?dl=0

    Any ideas?
    Last edited by Berilium2; 04-01-2015 at 06:45 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Remove duplicates function not removing duplicates

    Your file is causing some problems. Is it huge? Please cut it back to a reasonable size and post again (on this site, not an external site).
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    03-30-2015
    Location
    Ireland
    MS-Off Ver
    2007
    Posts
    2

    Re: Remove duplicates function not removing duplicates

    I can't cut it down to below 1mb without deleting nearly all of the data
    Here's a new link however which I hope works
    https://www.dropbox.com/s/i4ygc7bxy4...Test.xlsx?dl=0

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Remove duplicates function not removing duplicates

    Hi. I used Excel's remove duplicates function, selecting columns E to H and it appears to have removed 40,000+ rows - the total is now less than 400,000 rows.

+ 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. 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
  2. Remove duplicates without removing formatting?
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-28-2014, 06:48 PM
  3. [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
  4. [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
  5. 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