Forum Discussion
Deleting multiple values from the same second
Assuming your data is in column A:D then create a helper column E with the following formula...
=COUNTIF(A$2:A2,A2)=1
and then filter the column E with TRUE values.
Please refer to the attached for details.
Thank you for the reply!
But when I enter the =COUNTIF(A$2:A2,A2)=1 formula into column E, all of the values in column E end of being TRUE, except for the very last one..
Am I missing something?
If that's the case, it means all your values in column A are unique values. They may look duplicate but maybe they contain some leading or trailing spaces which make them all unique somehow.
Did you check the file I uploaded? It contains your sample data along with the formula in column E and data is filtered in column E for True values.
Also, check if the Calculation Options is set to Manual, if so, set it to Automatic.
If that doesn't resolve your issue, please upload the truncated version of your file in the question.
I think you are right, there must be some trailing milliseconds attached to my time that I cannot see, because your code does work when I manually type out a few lines of the data ( i.e enter 12:04:20). I have tried to reformat my time column to hh:mm:ss, but it still does not work. Is there a better way to truncate my time data to milliseconds are not included, and so that COUNTIF will recognize them as the same value?
