Having consolidated many marketing customer records into a single sheet I now have 30k records with many exact and near dupes of account name/address. (one row per contact name + the acct name and address).

What are my options to end up with a single 'master' account record for each acct with a unique ID tieing it to contacts at that acct so I can then import to a CRM app?

Is there some fuzzy match formulas I could use?

Cheers!
D