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)
How about using =UNIQUE( range, , TRUE) function to return the values and copy and 'paste values'