Define what duplicate means
Choose a stable key such as Customer ID rather than a changeable name. If no single field is unique, combine fields such as Entity plus Invoice Number.
Keep first or last
Keep first works for immutable imports; keep last works when later rows are confirmed updates. Neither rule is safe unless the source order has a clear business meaning.
Prefer non-empty or longest text
Keep non-empty is useful when one source fills gaps in another. Longest text can preserve fuller addresses or descriptions, but it may also retain verbose errors, so review samples.
Use numeric rules carefully
Highest or lowest can resolve quantities, limits, or timestamps only when that direction represents the intended truth. It should not be used blindly for prices or balances.
Join unique values when multiplicity is valid
Tags, phone numbers, and notes may legitimately contain more than one value. Join unique values with a consistent separator while keeping the change report for audit.
QUICK WORKFLOW
Complete the task in four controlled steps
- Select the worksheet and a duplicate key.
- Choose a default conflict rule.
- Override the rule for sensitive columns.
- Review resolved conflicts and export a new workbook.
COMMON QUESTIONS
Before you start
Is the newest row always the correct duplicate?
No. It is correct only when row order reliably represents update time and later records are authoritative.
Can different columns use different rules?
Yes. For example, keep the newest email, the longest address, and the highest verified limit within the same deduplication job.
简体中文
Excel重复数据冲突时应该保留哪一个值
删除完全相同的重复行并不难，真正困难的是同一客户或交易主键对应的姓名、日期、金额和联系方式不一致。
先定义什么叫重复
优先使用客户编号等稳定主键，不要只用容易变化的姓名。如果没有单一唯一字段，可以使用主体加发票号等组合键。
保留首条还是末条
首条适合不可变的首次导入，末条适合顺序明确的更新记录。如果数据顺序没有业务含义，这两个规则都不安全。
优先非空或最长文本
优先非空适合用一个来源补齐另一个来源的缺失值；最长文本有助于保留完整地址，但也可能保留冗长错误，需要抽样检查。
谨慎使用最高或最低值
只有当数值方向代表业务真相时才使用最高或最低规则，不能盲目应用于价格和余额。
允许多值时合并唯一值
标签、电话和备注可能允许多个值，可以用统一分隔符合并唯一内容，同时保留变更报告用于审计。
FIX IT IN YOUR BROWSER
Use the file on your device. Nothing gets uploaded.
Load a sample or choose your own files, confirm the result, and download a clean workbook.
Open the free tool