Remove Duplicates - Google Sheets add-on

Meet BRAND NEW Remove Duplicates collection in this video: https://www.youtube.com/watch?v=CHcu8jGpGsY
Install the latest version from the Google Workspace Marketplace: https://workspace.google.com/marketplace/app/remove_duplicates/347814268012

It takes 5 simple steps to compare two sheets for duplicates or highlight unique records in one table with this Google Sheets add-on.

Find a detailed description and a link to get the add-on on our website:
https://www.ablebits.com/google-sheets-add-ons/remove-duplicates/index.php

00:00 Intro
00:07 Compare Sheets or Columns tool
01:00 Find Duplicates or Uniques tool
01:41 Wrap-up

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

#spreadsheet #googlesheets #removeduplicates #ablebits

---

Closed Caption:

remove duplicates add-on helps you find
the same values within one sheet or in
two different tables once you get the
add-on you can start one of two wizards
from the add-ons menu there are five
simple steps you need to follow to
compare two sheets first select the main
table the one for showing the
results then select the sheet and the
range to compare
against step three lets you decide if
you want to find duplicate records or
the unique values in your
table choose the key columns to compare
in your sheets it doesn't matter if
their order is different you can always
use the headers to help you identify
columns with the same information you
can Mark as many columns as needed they
will be checked
simultaneously thus we can find records
that have not only the names matching
but also the
IDS then choose what to do with the
found values the current version of the
add-on lets you delete or highlight them
with any color you
choose you will get an overview of the
results when the add-on finishes its
work
to find duplicates within one sheet use
the find duplicates or uniques tool it
offers advanced search that can include
or exclude the first entries of the
duplicates the steps are very similar
Define the range with the data choose
what you are looking for for example you
can find only those records that do not
have dupes or include their first
entries into your
results select what columns they add
don't should scan we can look for
complete row matches or find records
with the same first and last name
names finally choose what to do you can
highlight or delete the found items soon
you will also be able to copy and move
the results or mark them with a
status this add-on is an excellent
assistant for keeping your Google Sheets
duplicate free if you have any questions
please share them on aable bits Forum
thank you for your attention