Share via

excel remove duplicate function bugged

Anonymous
2013-03-01T08:59:19+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-03-04T05:22:53+00:00

    I will from now sort first and use the function after

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-03-01T18:20:34+00:00

    Been running for the last 40 minutes so no luck there

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-03-01T17:39:54+00:00

    Just tried on a file with 677085 rows but not sure I did it right ;)

    List in range : $A$1:$N$677085

    criteria in range : $J$1:$J$677085 (that is the bit I am not sure about)

    Started to calculate and kind of hanged there , looking as if it was going through the data but not doing much.

    I let in run unless I have messed up the criteria in range

    Was this answer helpful?

    0 comments