Identifying duplicates when company name changes without changing source data
I am keeping a running report on engagement with certain organizations across 5 years. We receive a data export from a collaborating partner with a list of hundreds of orgs, thousands of rows. Each year, several orgs may change their names slightly (for example, if Super Duper Inc. changes its name to SuperSuper Inc. or Super Duper Kids Inc, but still in, say, Burbank, CA). Is there a formula for identifying these "similar" orgs to see if they need to be de-duped somehow (I use a helper column called "adjusted org name") rather than having to manually review? The purpose of this is to make sure we're not counting an org more than once when we run a pivot table (for instance, if Super Super Kids Inc got 4K in funding in 2022 and then SuperDuper Inc. received an in-kind donation of a TV in 2023, we want to see 2 engagements for 1 org over 2 years, not 2 engagements for 2 orgs).
Help Article Resources
Check out the Formula Handbook template!