HIGHLIGHTING DUPLICATES: GOOGLE SHEETS VS FLOOKUP

1

Google Sheets

Highlighting your data is a very good way to get an overview of what your data looks like before performing destructive operations like removing duplicates or using that data for any other purpose. Unfortunately, at the time of writing this article, Google Sheets does not provide a predefined way of highlighting duplicates. However, with custom formulas and conditional formatting, highlighting duplicates in your spreadsheet can be done in a few clicks.

#Project Management #Spreadsheets #No Code

2

Flookup

The result will be duplicates that have been identified despite differences in spelling. Please note that you can also choose to highlight duplicates by sound similarity by clicking Extensions > Flookup > Highlight duplicates > By sound and following steps similar to the ones above.

#Data Cleansing #Data Quality #Google Sheets 1 user reviews