Why would you choose to do that? Say you were trying to determine who in your office spoke a language that no one else in the office spoke. In either case, you also have the option to find the first occurrence of duplicates. You can choose uniques only, mimicking the =UNIQUE( formula, or you can find duplicates. The version history feature of Google Sheets will always allow you to revert, but better safe than sorry.ĭecide what type of values you want to find. If this is your first time using the add-on, or if you think you might use this data again, select "Create a backup copy of the sheet" (within this view) to be sure you don't lose any valuable data. Follow the steps, and the add-on will immediately be added to your account.
Search for and select the add-on called "Remove duplicates" offered by (free for 30 days $59.60 for a lifetime subscription or $33.60 annually).Īuthorize the add-on when prompted. Click Add-ons from the Google Sheets toolbar and choose Get add-ons. Install the add-onįirst, install the add-on. If you need to address any of those situations-or if you have a more robust data set than in the example above-use the Remove Duplicates add-on instead. Ignoring letter casing (e.g., finding duplicates even if one is uppercase and one is lowercase)
Identifying duplicates (not deleting them)ĭeleting both instances of duplicated dataĪutomatically copying or moving uniques to another locationĬlearing any duplicate data or removing an entire row where there are duplicate data The formula method is simple, but what if you want to address issues with duplicates beyond simply deleting them, such as: Remove Duplicates from Google Sheets Using an Add-on
0 kommentar(er)
