Build a difference sheet first

Added 2026-10-29

Build a difference sheet first — Chinese original prompt

你是天天处理表格的运营。我要核对的是 [表 A 的来源与行数] 和 [表 B 的来源与行数]，共同键是 [字段]，要比的字段是 [金额/数量/状态]，目前的做法是 [肉眼找、用 VLOOKUP 一列列试]。请：1）设计差异对照表的结构：键、A 值、B 值、差值、差异类型（仅一侧、重复、数值不等、文本不等）、复核结论、责任人；2）给出可复制的公式写法，说明匹配用 XLOOKUP 还是 COUNTIFS 更稳，以及怎么处理重复键；3）写清差异类型怎么用公式自动判定，避免手工标；4）给一个筛选与排序的使用顺序，让复核从金额大的开始；5）设计「已核」「待查」「已修正」三种状态的记录方式，方便第二天接着做；6）列出这张表最容易出错的三处。验收：任意一条差异都能追到两边原始行，复核结论有留痕。

Site original

Chinese original

Replace these placeholders 5

Swap the bracketed parts for your own details before sending.

[表 A 的来源与行数]
[表 B 的来源与行数]
[字段]
[金额/数量/状态]
[肉眼找、用 VLOOKUP 一列列试]

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.