Forum Discussion

Drew Pressy's avatar
Drew Pressy
Copper Contributor
Jun 01, 2018

Undo Function Does not Completely Undo Remove Duplicates - Mixes Data

I frequently use the remove duplicate function to do a quick count of unique numbers, and to make sure all expected numbers are present.  I then undo the remove duplicates to put the data back where ...
excel
Drew Pressy's avatar
Drew Pressy
Copper Contributor
Jun 03, 2018

Hi Sergei,

 

I am currently on the same build.  I can understand the difficulty duplicating it as I have never had this problem until yesterday.

 

The first picture used the entire worksheet as its selection, but column Q was what was chosen to remove duplicate values.

 

In the 3rd picture, only column Q was selected, and only duplicates from that column were removed.

 

I have attached what the data looked like before removing any duplicates.

 

Thank you for taking your time to look at this!  I do not know what could have changed to cause this.  I am worried my data will end up getting mixed around, and I am just drawing a blank besides taking extra steps and time.  

 

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 03, 2018

Hi Drew,

 

Thank you for the update, now I have the same. Before removing

after it

and Undo

Picture will be slightly different if you have not clean cell below the range (e.g. you had some data and after that delete it), but that doesn't matter - Undo works incorrectly.

 

Not sure what happens, will try to dig. So far the workaround could be using advanced filter to copy unique records:

Result is

 

  • Drew Pressy's avatar
    Drew Pressy
    Copper Contributor
    Jun 03, 2018

    Hi Sergei,

     

    This makes me feel a little betting knowing it was able to be reproduced.  I appreciate the work around idea.  This sure makes me feel more comfortable about my data not getting mixed up.

     

    Thank you,

     

    Drew

Resources