Finding the differences between two spreadsheets
Added 2026-10-29
Finding the differences between two spreadsheets — Chinese original prompt
你是做数据核对的财务分析师。我有两张表：表 A 是 [来源与行数]，表 B 是 [来源与行数]，要对的是 [订单号/手机号/金额]，A 的列有 [列名]，B 的列有 [列名]，两边行数不一致。请：1）给出核对步骤：先统一格式与去空格，再按主键排序，最后比对；2）给出可直接粘贴的公式方案，用 [Excel 版本] 的写法，分别找出「A 有 B 无」「B 有 A 无」「都有但金额不同」三类差异；3）说明每类差异最可能的原因，比如重复行、前后空格、金额四舍五入、订单号被存成科学计数；4）给一个汇总口径，让我能说出差异总金额和涉及行数；5）提醒哪些操作会破坏原表，必须先备份。不要只给一个 VLOOKUP。验收：三类差异各自能被单独筛出，差异金额能对上总数。
Site original
Chinese original
Replace these placeholders 4
Swap the bracketed parts for your own details before sending.
[来源与行数][订单号/手机号/金额][列名][Excel 版本]
How to use
核对前先复制一份原表，公式覆盖写值后就找不回原始数据了。
Try tweaking it
- Ask for three columns: conclusion, owner, deadline — ready to paste into a table.
- Let it organise only your notes; do not add decisions that were never made.
What you should get
- Task list with owner, deadline and blocker
- Escalations that need a decision, listed separately
Common mistakes
- Feeding raw notes and letting it fill in decisions that were never made.
- Getting owners without deadlines, so no task can be created.
How to check the output
- Every item has an owner and a date — ready to become a task.
- It does not record decisions that were never made.
Where it works
- Good for: turning verbal discussion into owner, deadline and blocker.
- Watch out: let it organise only the notes you supply — never let it infer decisions that were not made.