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?
Bookmarks