When you get a table or list from others or some systems, you might get duplicate records. If you wanted to find those duplicates whether it be in a one column table or a multiple column table, it's fairly easy to do within Google sheets. I'll show a couple of ways this can be done with formulas and with a Pivot Table. Also if you wanted to just delete duplicate records ( and didn't want to bother with the analysis of which records is a duplicate), closer to the end of the video I'll show the command to do this quickly.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.