Forum Discussion

Cartire2000's avatar
Cartire2000
Copper Contributor
Jul 27, 2022
Solved

Help with removing both values in a duplicate

I'm having a hard time with removing spurious data from a sheet. We have hundreds of thousands of unique codes that were accidently merged with incorrect data. This was done by a different party and thus we cant simply reverse the error. I have the incorrect values and know how to find the duplicates, but I dont want to remove just one entry, I want to remove both the original and the duplicate value.  

Is there a way I can do this without having to go line by line?  

  • Cartire2000 

    Are you looking to return only records appearing once?

    Here's a sample data set with dupes and after with only records appearing once:

    =UNIQUE(A2:C8,,1)

     

  • mtarler's avatar
    mtarler
    Silver Contributor
    How about using =UNIQUE( range, , TRUE) function to return the values and copy and 'paste values'
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    Cartire2000 

    Are you looking to return only records appearing once?

    Here's a sample data set with dupes and after with only records appearing once:

    =UNIQUE(A2:C8,,1)

     

    • Cartire2000's avatar
      Cartire2000
      Copper Contributor
      Thank you, this is what I needed. My internet research was stuck on the word "duplicate" and i didnt even think about looking at it that way.

Resources