Find Near-Duplicates in Google Sheets (Similar, Not Identical)
Remove duplicates, UNIQUE and COUNTIF only catch values that are exactly the same. Real lists are full of near-duplicates: "Acme Pty Ltd", "ACME Pty. Ltd" and "Acme Pty Limited" are one customer typed