excel remove duplicate function bugged

Question

Hello

I am using the function remove duplicate on a column and just realized that if you do not sort the data first you will have not removed all duplicates.

I have been looking around searching if this is a possible bug and it seems that many people reported it.

Will this be fixed soon?

I will keep sorting the data while using that function as it seems to be the way to go around that possible bug.

Issue can be repeated on excel 2010 windows 7 and windows 8

Thanks

Franck

Answer 1

I don't know.

You will need to experiment.

P.S.

Thanks again for the data.  I now have a short, simple, example of the bug!

Answer 2

Thanks Gary,

I will have a go at that too, hopefully it computes when it comes to file having more than 500 rows and about 20 columns.

Would this option filter on one column only and export the data keeping its integrity ?

Answer 3

I will give a go to your macro, but not sure that it will work on the spreadsheets I am usually working on.

One other ways is to do a simple =if

=IF(J2=J3,"dup","0")

but again that only works with sorting first

Answer 4

Thanks!