30k records to de dupe, fuzzy match?

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

There is no fuzzy logic in excel.

However, you can upload example excel workbook with some instances you like to compare and join and there might be a solution for most of your records to downsize your database.

Avoid important data but keep examples to match your original data. Give as many inputs and desired outputs to clarify your issue.