The Scenario
You manage direct mail for a retailer. The post-campaign analysis request landed in your inbox: "Deduplicate the mailing list before the next print drop." The 6,000-row customer address list in Excel was assembled over two years from web forms, in-store signups, and a purchased list.
"14 Elm Street" and "14 Elm St." are the same address. The print vendor charges per piece.
The bad version:
- Sort by ZIP code then street name and eyeball adjacent rows — works until "Street" vs "St" breaks the sort and duplicates scatter.
- Write a COUNTIF against a CONCATENATE of address columns — catches exact duplicates only, misses every formatting variant.
- Export to a fuzzy matching script, spend two hours on setup, discover it can't handle apartment numbers inline.
The vendor wants the file by Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Excel workbook and calls Interzoid's address match key API for every row.
For each address in column A, generate an Interzoid address match key and write it to column B, then highlight any rows sharing the same key as likely duplicates.
What You Get
- Column B: Interzoid address match key per row.
- Rows sharing the same key highlighted — "14 Elm Street" and "14 Elm St." share a key and appear as adjacent highlighted rows.
- A duplicate cluster count at the top so you know the scale before reviewing.
What If the Data Is Not Quite Ready
Addresses include city and state — you want to match on street only
Extract only the street portion from each address in column A (text before the first comma), write to column B, then generate an Interzoid address match key for column B and write it to column C. Highlight rows sharing the same key.
You want to flag without re-sorting the workbook
Generate Interzoid global address similarity keys for every row in column A and write them to column B, then add a COUNTIF in column C to flag keys that appear more than once.
Some rows have blank addresses
Skip rows where column A is blank. For all other rows, generate an Interzoid address match key and write to column B. Flag blank rows as 'BLANK' in column B.
Full dedup workflow in one shot
For each address in column A, generate an Interzoid address match key and write to column B. Add a COUNTIF in column C showing how many times each key appears. Flag rows where column C is greater than 1 as 'DUPLICATE' in column D. Create a worksheet called 'Duplicates' containing only flagged rows, sorted by column B, for the vendor's review.
The deduplicated file goes to the vendor Wednesday afternoon.
Try It
Get the 7-day free trial of SheetXAI and open your customer address workbook — ask SheetXAI to generate address match keys and flag duplicates in column A before the print vendor deadline. Then see the spoke on parsing free-form addresses into structured columns, or the full Interzoid integration overview.