Forum Discussion
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 ...
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)
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)
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.
- You're welcome!