Forum Discussion
Cartire2000
Jul 27, 2022Copper Contributor
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?
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)
- mtarlerSilver ContributorHow about using =UNIQUE( range, , TRUE) function to return the values and copy and 'paste values'
- Patrick2788Silver Contributor
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)
- Cartire2000Copper ContributorThank 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.
- Patrick2788Silver ContributorYou're welcome!