This feature allows you to identify duplicates between two different Google Sheets.
⬇️ Prerequisites ⬇️
2 sheets containing at least one column with a similar header (e.g., a "Fullname" column in each sheet)
🟡 How to use it?
Click on the Remove duplicates feature in the "Tools" tab of the homepage
Select the first Google Sheet to compare from the first dropdown
Select the second Google Sheet to compare from the second dropdown
Then check the columns you want to compare between the two sheets (Note: To compare two columns, they must have the same header name)
📺 If you haven't fully understood how the Derrick's Remove duplicates feature works, I recommend watching the following video 📺