1 line
121 KiB
Plaintext
1 line
121 KiB
Plaintext
{"ID":"20250915093450-bwdthap","Spec":"2","Type":"NodeDocument","Properties":{"id":"20250915093450-bwdthap","title":"数据库EXCEL尝试","type":"doc","updated":"20250916154053"},"Children":[{"ID":"20250915112645-0rzeinu","Type":"NodeParagraph","Properties":{"id":"20250915112645-0rzeinu","updated":"20250915112717"},"Children":[{"Type":"NodeText","Data":"与2025_09_15_11:25完成"}]},{"ID":"20250915112718-ihvhcuh","Type":"NodeParagraph","Properties":{"id":"20250915112718-ihvhcuh","updated":"20250915113859"},"Children":[{"Type":"NodeText","Data":"新问题，如何去除掉0，和#\tN/A"}]},{"ID":"20250915113813-d6g65nz","Type":"NodeParagraph","Properties":{"id":"20250915113813-d6g65nz","updated":"20250915113813"}},{"ID":"20250915114117-obr8ae7","Type":"NodeParagraph","Properties":{"id":"20250915114117-obr8ae7","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"好的，在 Excel 中去除 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"0"},{"Type":"NodeText","Data":" 和 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":" 错误值是常见的数据清理需求。根据你的最终目的（是单纯为了“看起来干净”还是为了“后续计算”），有以下几种方法。"}]},{"ID":"20250915114117-yfdrzvf","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915114117-yfdrzvf","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"方法一：使用 IF 和 IFERROR 函数组合（推荐用于后续计算）"}]},{"ID":"20250915114117-ubis0df","Type":"NodeParagraph","Properties":{"id":"20250915114117-ubis0df","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"这是最灵活、最常用的方法，它会在源数据基础上创建一个新的、干净的数据列，不影响原始数据，便于后续的统计、计算或制作图表。"}]},{"ID":"20250915114117-ad529ya","Type":"NodeParagraph","Properties":{"id":"20250915114117-ad529ya","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式原理："}]},{"ID":"20250915114117-syjpkix","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915114117-syjpkix","updated":"20250915114117"},"Children":[{"ID":"20250915114117-fvl5ugj","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915114117-fvl5ugj","updated":"20250915114117"},"Children":[{"ID":"20250915114117-xf0uuil","Type":"NodeParagraph","Properties":{"id":"20250915114117-xf0uuil","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"先用 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IFERROR"},{"Type":"NodeText","Data":" 函数将 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":" 等错误值转换为空单元格 ("},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\"\""},{"Type":"NodeText","Data":") 或其他值（如 0）。"}]}]},{"ID":"20250915114117-7px9akz","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915114117-7px9akz","updated":"20250915114117"},"Children":[{"ID":"20250915114117-9l1x0yk","Type":"NodeParagraph","Properties":{"id":"20250915114117-9l1x0yk","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"再在外层套一个 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF"},{"Type":"NodeText","Data":" 函数，判断上一步的结果是否为 0，如果是则也转换为空单元格。"}]}]}]},{"ID":"20250915114117-3kvs2cp","Type":"NodeParagraph","Properties":{"id":"20250915114117-3kvs2cp","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"假设原始数据在 A 列，从 A2 开始。"}]},{"ID":"20250915114117-sze9c4t","Type":"NodeParagraph","Properties":{"id":"20250915114117-sze9c4t","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"在 B2 单元格输入以下公式，然后向下填充："}]},{"ID":"20250915114117-vb3xa6e","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915114117-vb3xa6e","updated":"20250915114117"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IF(IFERROR(A2, \"\")=0, \"\", IFERROR(A2, \"\"))\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915114117-6h9bt1g","Type":"NodeParagraph","Properties":{"id":"20250915114117-6h9bt1g","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式解释："}]},{"ID":"20250915114117-dwdjpxo","Type":"NodeList","ListData":{},"Properties":{"id":"20250915114117-dwdjpxo","updated":"20250915114117"},"Children":[{"ID":"20250915114117-vao0f9s","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915114117-vao0f9s","updated":"20250915114117"},"Children":[{"ID":"20250915114117-3cuv6wg","Type":"NodeParagraph","Properties":{"id":"20250915114117-3cuv6wg","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IFERROR(A2, \"\")"},{"Type":"NodeText","Data":"：如果 A2 是错误（如 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":"），则返回空字符串 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\"\""},{"Type":"NodeText","Data":"；否则返回 A2 本身的值。"}]}]},{"ID":"20250915114117-x5mw3ki","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915114117-x5mw3ki","updated":"20250915114117"},"Children":[{"ID":"20250915114117-318r8pb","Type":"NodeParagraph","Properties":{"id":"20250915114117-318r8pb","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"外层的 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF( ... =0, \"\", ... )"},{"Type":"NodeText","Data":"：判断内层公式的结果是否等于 0。如果是，返回空字符串 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\"\""},{"Type":"NodeText","Data":"；否则，返回内层公式的结果。"}]}]}]},{"ID":"20250915114117-olpf0zt","Type":"NodeParagraph","Properties":{"id":"20250915114117-olpf0zt","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"效果："}]},{"ID":"20250915114117-p5bl6zq","Type":"NodeTable","TableAligns":[1,1],"Properties":{"colgroup":"|","id":"20250915114117-p5bl6zq","updated":"20250915114117"},"Children":[{"Type":"NodeTableHead","Data":"thead","Children":[{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"原始数据 (A列)"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"清理后数据 (B列)"}]}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"5"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"5"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"0"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"em","TextMarkTextContent":"(空单元格)"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":""}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"em","TextMarkTextContent":"(空单元格)"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"3.14"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"3.14"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"-2"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"-2"}]}]}]},{"ID":"20250915114117-4g6k0bh","Type":"NodeParagraph","Properties":{"id":"20250915114117-4g6k0bh","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点："},{"Type":"NodeText","Data":" 处理后的结果是真正的空单元格或数字，可以被 SUM, AVERAGE 等函数直接忽略计算。\n"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点："},{"Type":"NodeText","Data":" 需要增加一个辅助列。"}]},{"ID":"20250915114117-d4j2bcg","Type":"NodeThematicBreak","Properties":{"id":"20250915114117-d4j2bcg","updated":"20250915114117"}},{"ID":"20250915114117-czyny9t","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915114117-czyny9t","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"方法二：使用“转到特殊”功能批量删除（一次性操作）"}]},{"ID":"20250915114117-ug958el","Type":"NodeParagraph","Properties":{"id":"20250915114117-ug958el","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"如果你的目的是"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"快速清理一片区域中的 0 值"},{"Type":"NodeText","Data":"（错误值无法用此法），并且不介意"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"直接修改原始数据"},{"Type":"NodeText","Data":"，可以使用此方法。"}]},{"ID":"20250915114117-ejgylb3","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915114117-ejgylb3","updated":"20250915114117"},"Children":[{"ID":"20250915114117-dj5ijpa","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915114117-dj5ijpa","updated":"20250915114117"},"Children":[{"ID":"20250915114117-5960oek","Type":"NodeParagraph","Properties":{"id":"20250915114117-5960oek","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"选中"},{"Type":"NodeText","Data":"包含 0 值的单元格区域。"}]}]},{"ID":"20250915114117-tsu5vp6","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915114117-tsu5vp6","updated":"20250915114117"},"Children":[{"ID":"20250915114117-rckx04l","Type":"NodeParagraph","Properties":{"id":"20250915114117-rckx04l","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"按下 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Ctrl + G"},{"Type":"NodeText","Data":"（或 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"F5"},{"Type":"NodeText","Data":"）打开“定位”对话框。"}]}]},{"ID":"20250915114117-q9a3vp1","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915114117-q9a3vp1","updated":"20250915114117"},"Children":[{"ID":"20250915114117-luz7e53","Type":"NodeParagraph","Properties":{"id":"20250915114117-luz7e53","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击左下角的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“定位条件”"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915114117-dwc7l2b","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915114117-dwc7l2b","updated":"20250915114117"},"Children":[{"ID":"20250915114117-rz9rhjp","Type":"NodeParagraph","Properties":{"id":"20250915114117-rz9rhjp","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"在弹出的窗口中，选择 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“常量”"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915114117-9m6s97m","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915114117-9m6s97m","updated":"20250915114117"},"Children":[{"ID":"20250915114117-ts65qq2","Type":"NodeParagraph","Properties":{"id":"20250915114117-ts65qq2","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"在“常量”选项中，"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"只勾选 “零”"},{"Type":"NodeText","Data":"，然后点击“确定”。此时所有值为 0 的单元格都会被选中。"}]}]},{"ID":"20250915114117-tedqibx","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Ni4=","Num":6},"Properties":{"id":"20250915114117-tedqibx","updated":"20250915114117"},"Children":[{"ID":"20250915114117-253kc78","Type":"NodeParagraph","Properties":{"id":"20250915114117-253kc78","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"直接按 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Delete"},{"Type":"NodeText","Data":" 键，即可将所有选中的 0 值删除。"}]}]}]},{"ID":"20250915114117-d8xp1yh","Type":"NodeParagraph","Properties":{"id":"20250915114117-d8xp1yh","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"注意："},{"Type":"NodeText","Data":" 此方法无法处理 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":" 错误。"}]},{"ID":"20250915114117-38k7iq6","Type":"NodeThematicBreak","Properties":{"id":"20250915114117-38k7iq6","updated":"20250915114117"}},{"ID":"20250915114117-hroqt02","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915114117-hroqt02","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"方法三：使用“查找和替换”功能（一次性操作）"}]},{"ID":"20250915114117-i4tsg5y","Type":"NodeParagraph","Properties":{"id":"20250915114117-i4tsg5y","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"此方法同样用于"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"直接修改原始数据"},{"Type":"NodeText","Data":"，可以分别处理 0 和错误值。"}]},{"ID":"20250915114117-g7aase8","Type":"NodeParagraph","Properties":{"id":"20250915114117-g7aase8","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"替换 0 值："}]},{"ID":"20250915114117-30ancih","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915114117-30ancih","updated":"20250915114117"},"Children":[{"ID":"20250915114117-6mhkv5s","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915114117-6mhkv5s","updated":"20250915114117"},"Children":[{"ID":"20250915114117-63nz0ps","Type":"NodeParagraph","Properties":{"id":"20250915114117-63nz0ps","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"选中目标区域。"}]}]},{"ID":"20250915114117-x9cdo21","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915114117-x9cdo21","updated":"20250915114117"},"Children":[{"ID":"20250915114117-7u25td8","Type":"NodeParagraph","Properties":{"id":"20250915114117-7u25td8","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"按 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Ctrl + H"},{"Type":"NodeText","Data":" 打开“查找和替换”对话框。"}]}]},{"ID":"20250915114117-66qeenu","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915114117-66qeenu","updated":"20250915114117"},"Children":[{"ID":"20250915114117-mfqvsy5","Type":"NodeParagraph","Properties":{"id":"20250915114117-mfqvsy5","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"查找内容"},{"Type":"NodeText","Data":"输入："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"0"},{"Type":"NodeText","Data":""}]}]},{"ID":"20250915114117-s5xazal","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915114117-s5xazal","updated":"20250915114117"},"Children":[{"ID":"20250915114117-zysq5r1","Type":"NodeParagraph","Properties":{"id":"20250915114117-zysq5r1","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"替换为"},{"Type":"NodeText","Data":"输入："},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"留空"},{"Type":"NodeText","Data":"（什么都不填）"}]}]},{"ID":"20250915114117-2s6mdh9","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915114117-2s6mdh9","updated":"20250915114117"},"Children":[{"ID":"20250915114117-dchx221","Type":"NodeParagraph","Properties":{"id":"20250915114117-dchx221","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“选项”"},{"Type":"NodeText","Data":"，并勾选 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“单元格匹配”"},{"Type":"NodeText","Data":"（"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"这一步非常重要！"},{"Type":"NodeText","Data":" 如果不勾选，像 10, 20 这样的数字中的 0 也会被替换掉）。"}]}]},{"ID":"20250915114117-1q2m29x","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Ni4=","Num":6},"Properties":{"id":"20250915114117-1q2m29x","updated":"20250915114117"},"Children":[{"ID":"20250915114117-d24py6y","Type":"NodeParagraph","Properties":{"id":"20250915114117-d24py6y","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击“全部替换”。"}]}]}]},{"ID":"20250915114117-vzuy5rs","Type":"NodeParagraph","Properties":{"id":"20250915114117-vzuy5rs","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"替换错误值（如 #N/A）："},{"Type":"NodeText","Data":"\nExcel 的普通查找替换无法直接定位错误值，但可以借助“查找”功能。"}]},{"ID":"20250915114117-4eidub9","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915114117-4eidub9","updated":"20250915114117"},"Children":[{"ID":"20250915114117-hcl9pdc","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915114117-hcl9pdc","updated":"20250915114117"},"Children":[{"ID":"20250915114117-cjdh9lq","Type":"NodeParagraph","Properties":{"id":"20250915114117-cjdh9lq","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"选中目标区域。"}]}]},{"ID":"20250915114117-smbgux9","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915114117-smbgux9","updated":"20250915114117"},"Children":[{"ID":"20250915114117-iohq20z","Type":"NodeParagraph","Properties":{"id":"20250915114117-iohq20z","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"按 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Ctrl + F"},{"Type":"NodeText","Data":" 打开“查找”对话框。"}]}]},{"ID":"20250915114117-i3hutht","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915114117-i3hutht","updated":"20250915114117"},"Children":[{"ID":"20250915114117-2mjgoh0","Type":"NodeParagraph","Properties":{"id":"20250915114117-2mjgoh0","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"查找内容"},{"Type":"NodeText","Data":"输入："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":""}]}]},{"ID":"20250915114117-8j98dxi","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915114117-8j98dxi","updated":"20250915114117"},"Children":[{"ID":"20250915114117-57jeu9s","Type":"NodeParagraph","Properties":{"id":"20250915114117-57jeu9s","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击“查找全部”。"}]}]},{"ID":"20250915114117-j0rocy1","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915114117-j0rocy1","updated":"20250915114117"},"Children":[{"ID":"20250915114117-g5vyaex","Type":"NodeParagraph","Properties":{"id":"20250915114117-g5vyaex","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"按 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Ctrl + A"},{"Type":"NodeText","Data":" 选中查找到的所有单元格。"}]}]},{"ID":"20250915114117-yuftzg4","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Ni4=","Num":6},"Properties":{"id":"20250915114117-yuftzg4","updated":"20250915114117"},"Children":[{"ID":"20250915114117-e92727c","Type":"NodeParagraph","Properties":{"id":"20250915114117-e92727c","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"关闭查找对话框，直接按 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Delete"},{"Type":"NodeText","Data":" 键删除。"}]}]}]},{"ID":"20250915114117-r1cduia","Type":"NodeParagraph","Properties":{"id":"20250915114117-r1cduia","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点："},{"Type":"NodeText","Data":" 同样会直接修改原始数据，且操作相对繁琐。"}]},{"ID":"20250915114117-zuu9gds","Type":"NodeThematicBreak","Properties":{"id":"20250915114117-zuu9gds","updated":"20250915114117"}},{"ID":"20250915114117-o7zs5lp","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915114117-o7zs5lp","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"方法四：使用“筛选”功能隐藏（仅用于显示）"}]},{"ID":"20250915114117-kkazyh5","Type":"NodeParagraph","Properties":{"id":"20250915114117-kkazyh5","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"如果你的目的仅仅是"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"让表格看起来整洁"},{"Type":"NodeText","Data":"，而不需要修改数据或用于计算，可以使用筛选功能。"}]},{"ID":"20250915114117-zfoxtza","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915114117-zfoxtza","updated":"20250915114117"},"Children":[{"ID":"20250915114117-c9hnmkc","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915114117-c9hnmkc","updated":"20250915114117"},"Children":[{"ID":"20250915114117-yfgbno0","Type":"NodeParagraph","Properties":{"id":"20250915114117-yfgbno0","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"选中数据区域的标题行。"}]}]},{"ID":"20250915114117-zktmymd","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915114117-zktmymd","updated":"20250915114117"},"Children":[{"ID":"20250915114117-wqg2l1k","Type":"NodeParagraph","Properties":{"id":"20250915114117-wqg2l1k","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“数据”"},{"Type":"NodeText","Data":" 选项卡 \u003e "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“筛选”"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915114117-o5l5d1g","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915114117-o5l5d1g","updated":"20250915114117"},"Children":[{"ID":"20250915114117-veu6w2b","Type":"NodeParagraph","Properties":{"id":"20250915114117-veu6w2b","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击列标题上的下拉箭头。"}]}]},{"ID":"20250915114117-j6ayp0p","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915114117-j6ayp0p","updated":"20250915114117"},"Children":[{"ID":"20250915114117-ai9m17r","Type":"NodeParagraph","Properties":{"id":"20250915114117-ai9m17r","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"取消勾选 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"0"},{"Type":"NodeText","Data":" 和 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":"（或其他不想显示的值）。"}]}]},{"ID":"20250915114117-eqi80af","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915114117-eqi80af","updated":"20250915114117"},"Children":[{"ID":"20250915114117-d8a56k8","Type":"NodeParagraph","Properties":{"id":"20250915114117-d8a56k8","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"点击“确定”。"}]}]}]},{"ID":"20250915114117-33573cj","Type":"NodeParagraph","Properties":{"id":"20250915114117-33573cj","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"效果："},{"Type":"NodeText","Data":" 不满足条件的行会被隐藏起来，但数据本身依然存在。"}]},{"ID":"20250915114117-weksrd3","Type":"NodeThematicBreak","Properties":{"id":"20250915114117-weksrd3","updated":"20250915114117"}},{"ID":"20250915114117-pw1558u","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915114117-pw1558u","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"总结与推荐"}]},{"ID":"20250915114117-b4qimlp","Type":"NodeTable","TableAligns":[1,1,1,1],"Properties":{"colgroup":"|||","id":"20250915114117-b4qimlp","updated":"20250915114117"},"Children":[{"Type":"NodeTableHead","Data":"thead","Children":[{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"方法"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"优点"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"缺点"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"适用场景"}]}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"IF+IFERROR公式"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"不破坏原数据，结果可用于计算，最灵活"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"需要创建辅助列"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"最推荐"},{"Type":"NodeText","Data":"，用于数据预处理和后续分析"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"定位/查找替换"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"直接修改原数据，快速"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"可能误操作，无法智能处理错误值"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"快速清理纯数字表格中的 0"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"筛选"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"操作简单，不改变数据"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"数据只是被隐藏，计算时仍会包含"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"临时查看数据，打印"}]}]}]},{"ID":"20250915114117-sfhhobi","Type":"NodeParagraph","Properties":{"id":"20250915114117-sfhhobi","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"因此，对于大多数情况，强烈推荐使用【方法一】的公式组合。"}]},{"ID":"20250915131216-37ds2im","Type":"NodeParagraph","Properties":{"id":"20250915131216-37ds2im","updated":"20250915131216"}},{"ID":"20250915131217-b4ilz3x","Type":"NodeParagraph","Properties":{"id":"20250915131217-b4ilz3x","updated":"20250915131217"}},{"ID":"20250915131218-fxtybk2","Type":"NodeParagraph","Properties":{"id":"20250915131218-fxtybk2","updated":"20250915131218"}},{"ID":"20250915131315-ywlvbuh","Type":"NodeParagraph","Properties":{"id":"20250915131315-ywlvbuh","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"好的，在 Excel 中匹配一个表里是否有另一个表里的值，这是一个非常常见的需求（通常称为“查重”或“存在性检查”）。根据你的Excel版本和具体需求，有几种主流方法。"}]},{"ID":"20250915131315-enge11b","Type":"NodeParagraph","Properties":{"id":"20250915131315-enge11b","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"我将以这个场景为例进行说明："}]},{"ID":"20250915131315-u6i5kq1","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-u6i5kq1","updated":"20250915131315"},"Children":[{"ID":"20250915131315-wft9cjs","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-wft9cjs","updated":"20250915131315"},"Children":[{"ID":"20250915131315-3s7legv","Type":"NodeParagraph","Properties":{"id":"20250915131315-3s7legv","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"表A (名单表)"},{"Type":"NodeText","Data":"：一列数据，你想知道这里的每一项是否在另一个表中存在。"}]}]},{"ID":"20250915131315-dnv87vc","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-dnv87vc","updated":"20250915131315"},"Children":[{"ID":"20250915131315-nfzur4a","Type":"NodeParagraph","Properties":{"id":"20250915131315-nfzur4a","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"表B (参考表)"},{"Type":"NodeText","Data":"：作为参考依据的数据表。"}]}]}]},{"ID":"20250915131315-k0rolwx","Type":"NodeParagraph","Properties":{"id":"20250915131315-k0rolwx","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"假设："}]},{"ID":"20250915131315-wkcbwss","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-wkcbwss","updated":"20250915131315"},"Children":[{"ID":"20250915131315-h7sjaz2","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-h7sjaz2","updated":"20250915131315"},"Children":[{"ID":"20250915131315-4ofda3l","Type":"NodeParagraph","Properties":{"id":"20250915131315-4ofda3l","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"名单表在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A100"},{"Type":"NodeText","Data":""}]}]},{"ID":"20250915131315-dq82zxn","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-dq82zxn","updated":"20250915131315"},"Children":[{"ID":"20250915131315-wtcmxho","Type":"NodeParagraph","Properties":{"id":"20250915131315-wtcmxho","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"参考表在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet2"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A500"},{"Type":"NodeText","Data":""}]}]}]},{"ID":"20250915131315-blq7xbl","Type":"NodeParagraph","Properties":{"id":"20250915131315-blq7xbl","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"你的目标是在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"B2:B100"},{"Type":"NodeText","Data":" 显示匹配结果（例如“存在”或“不存在”）。"}]},{"ID":"20250915131315-czpagq9","Type":"NodeThematicBreak","Properties":{"id":"20250915131315-czpagq9","updated":"20250915131315"}},{"ID":"20250915131315-rbizu73","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915131315-rbizu73","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"方法一：使用 COUNTIF 函数（最通用、兼容性最好）"}]},{"ID":"20250915131315-vunqme4","Type":"NodeParagraph","Properties":{"id":"20250915131315-vunqme4","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"这是最经典的方法，适用于所有版本的 Excel。"}]},{"ID":"20250915131315-zgjdx18","Type":"NodeParagraph","Properties":{"id":"20250915131315-zgjdx18","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式原理"},{"Type":"NodeText","Data":"：统计参考表中某个值出现的次数。如果次数大于0，则说明存在。"}]},{"ID":"20250915131315-mbg1qwy","Type":"NodeParagraph","Properties":{"id":"20250915131315-mbg1qwy","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"B2"},{"Type":"NodeText","Data":" 单元格输入以下公式，然后向下拖动填充："}]},{"ID":"20250915131315-yvt733q","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-yvt733q","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IF(COUNTIF(Sheet2!$A$2:$A$500, A2) \u003e 0, \"存在\", \"不存在\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-tu9ef4u","Type":"NodeParagraph","Properties":{"id":"20250915131315-tu9ef4u","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式解释"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-ru42ohn","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-ru42ohn","updated":"20250915131315"},"Children":[{"ID":"20250915131315-759v7ix","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-759v7ix","updated":"20250915131315"},"Children":[{"ID":"20250915131315-sogdb3v","Type":"NodeParagraph","Properties":{"id":"20250915131315-sogdb3v","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"COUNTIF(Sheet2!$A$2:$A$500, A2)"},{"Type":"NodeText","Data":"：在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet2"},{"Type":"NodeText","Data":" 的 A 列中查找当前单元格 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2"},{"Type":"NodeText","Data":" 的值出现了几次。"}]}]},{"ID":"20250915131315-2iuz3sj","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-2iuz3sj","updated":"20250915131315"},"Children":[{"ID":"20250915131315-m45ln0v","Type":"NodeParagraph","Properties":{"id":"20250915131315-m45ln0v","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF(... \u0026gt; 0, \"存在\", \"不存在\")"},{"Type":"NodeText","Data":"：如果出现次数大于0，返回“存在”，否则返回“不存在”。"}]}]}]},{"ID":"20250915131315-1l4y6mb","Type":"NodeParagraph","Properties":{"id":"20250915131315-1l4y6mb","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-pk2yjv0","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-pk2yjv0","updated":"20250915131315"},"Children":[{"ID":"20250915131315-t2tjbnv","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-t2tjbnv","updated":"20250915131315"},"Children":[{"ID":"20250915131315-q6nwhqh","Type":"NodeParagraph","Properties":{"id":"20250915131315-q6nwhqh","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"非常容易理解和记忆。"}]}]},{"ID":"20250915131315-hlrwaau","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-hlrwaau","updated":"20250915131315"},"Children":[{"ID":"20250915131315-9jiv49h","Type":"NodeParagraph","Properties":{"id":"20250915131315-9jiv49h","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"适用于数字、文本等各种数据类型。"}]}]},{"ID":"20250915131315-gmwhrud","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-gmwhrud","updated":"20250915131315"},"Children":[{"ID":"20250915131315-krp1uic","Type":"NodeParagraph","Properties":{"id":"20250915131315-krp1uic","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"所有Excel版本都支持。"}]}]}]},{"ID":"20250915131315-0ar48qn","Type":"NodeParagraph","Properties":{"id":"20250915131315-0ar48qn","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-apt32ql","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-apt32ql","updated":"20250915131315"},"Children":[{"ID":"20250915131315-ugkemgi","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-ugkemgi","updated":"20250915131315"},"Children":[{"ID":"20250915131315-10ud01j","Type":"NodeParagraph","Properties":{"id":"20250915131315-10ud01j","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"如果参考表数据量极大（例如数十万行），计算速度可能稍慢。"}]}]}]},{"ID":"20250915131315-0h7nkfw","Type":"NodeParagraph","Properties":{"id":"20250915131315-0h7nkfw","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"变体"},{"Type":"NodeText","Data":"：如果你只需要显示 TRUE/FALSE 而不需要文字，公式可以简化为："}]},{"ID":"20250915131315-puu37l3","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-puu37l3","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=COUNTIF(Sheet2!$A$2:$A$500, A2)\u003e0\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-scie23u","Type":"NodeThematicBreak","Properties":{"id":"20250915131315-scie23u","updated":"20250915131315"}},{"ID":"20250915131315-ny9l1gy","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915131315-ny9l1gy","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"方法二：使用 VLOOKUP 函数（经典查找法）"}]},{"ID":"20250915131315-23ryt7v","Type":"NodeParagraph","Properties":{"id":"20250915131315-23ryt7v","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"VLOOKUP 本身是用于查找并返回对应值的，但我们可以利用它找不到值会返回错误的特点来判断是否存在。"}]},{"ID":"20250915131315-m7tjeba","Type":"NodeParagraph","Properties":{"id":"20250915131315-m7tjeba","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"B2"},{"Type":"NodeText","Data":" 单元格输入以下公式，然后向下拖动填充："}]},{"ID":"20250915131315-195wph3","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-195wph3","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IF(ISNA(VLOOKUP(A2, Sheet2!$A$2:$A$500, 1, FALSE)), \"不存在\", \"存在\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-t1150bl","Type":"NodeParagraph","Properties":{"id":"20250915131315-t1150bl","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式解释"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-gbi0y51","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-gbi0y51","updated":"20250915131315"},"Children":[{"ID":"20250915131315-gzrff0u","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-gzrff0u","updated":"20250915131315"},"Children":[{"ID":"20250915131315-1yvq08j","Type":"NodeParagraph","Properties":{"id":"20250915131315-1yvq08j","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"VLOOKUP(A2, Sheet2!$A$2:$A$500, 1, FALSE)"},{"Type":"NodeText","Data":"：精确查找 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2"},{"Type":"NodeText","Data":" 的值在参考表中是否存在。"}]}]},{"ID":"20250915131315-rbys83u","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-rbys83u","updated":"20250915131315"},"Children":[{"ID":"20250915131315-9a6zu1a","Type":"NodeParagraph","Properties":{"id":"20250915131315-9a6zu1a","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ISNA(...)"},{"Type":"NodeText","Data":"：判断 VLOOKUP 的结果是否是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":" 错误（即找不到）。"}]}]},{"ID":"20250915131315-rhmb84z","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-rhmb84z","updated":"20250915131315"},"Children":[{"ID":"20250915131315-id3eyjn","Type":"NodeParagraph","Properties":{"id":"20250915131315-id3eyjn","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF(ISNA(...), \"不存在\", \"存在\")"},{"Type":"NodeText","Data":"：如果是错误，返回“不存在”，否则返回“存在”。"}]}]}]},{"ID":"20250915131315-rumql4f","Type":"NodeParagraph","Properties":{"id":"20250915131315-rumql4f","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-5pvm55f","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-5pvm55f","updated":"20250915131315"},"Children":[{"ID":"20250915131315-hqihft0","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-hqihft0","updated":"20250915131315"},"Children":[{"ID":"20250915131315-cxav6da","Type":"NodeParagraph","Properties":{"id":"20250915131315-cxav6da","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"同样是通用方法，兼容性好。"}]}]}]},{"ID":"20250915131315-2b2fn3n","Type":"NodeParagraph","Properties":{"id":"20250915131315-2b2fn3n","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-tta1rdy","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-tta1rdy","updated":"20250915131315"},"Children":[{"ID":"20250915131315-0mkglh6","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-0mkglh6","updated":"20250915131315"},"Children":[{"ID":"20250915131315-a3ife4l","Type":"NodeParagraph","Properties":{"id":"20250915131315-a3ife4l","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"公式比 COUNTIF 稍长，理解起来复杂一点。"}]}]},{"ID":"20250915131315-20pqayw","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-20pqayw","updated":"20250915131315"},"Children":[{"ID":"20250915131315-4mdw3l5","Type":"NodeParagraph","Properties":{"id":"20250915131315-4mdw3l5","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"同样有性能问题。"}]}]}]},{"ID":"20250915131315-2fq27ua","Type":"NodeThematicBreak","Properties":{"id":"20250915131315-2fq27ua","updated":"20250915131315"}},{"ID":"20250915131315-9mb5qe6","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915131315-9mb5qe6","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"方法三：使用 XLOOKUP 函数（最新、最强大，推荐Office 365用户使用）"}]},{"ID":"20250915131315-iw13yfj","Type":"NodeParagraph","Properties":{"id":"20250915131315-iw13yfj","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"如果你使用的是 Microsoft 365 或 Excel 2021 及以上版本，"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"XLOOKUP"},{"Type":"NodeText","Data":" 是最佳选择，语法更简洁，功能更强。"}]},{"ID":"20250915131315-bufen8q","Type":"NodeParagraph","Properties":{"id":"20250915131315-bufen8q","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"B2"},{"Type":"NodeText","Data":" 单元格输入以下公式，然后向下拖动填充："}]},{"ID":"20250915131315-7j2plu9","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-7j2plu9","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IF(ISNA(XLOOKUP(A2, Sheet2!$A$2:$A$500, Sheet2!$A$2:$A$500)), \"不存在\", \"存在\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-sktvh0g","Type":"NodeParagraph","Properties":{"id":"20250915131315-sktvh0g","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"或者，利用 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"XLOOKUP"},{"Type":"NodeText","Data":" 的第四个参数直接处理错误："}]},{"ID":"20250915131315-vk3s8d2","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-vk3s8d2","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IFNA(XLOOKUP(A2, Sheet2!$A$2:$A$500, \"存在\"), \"不存在\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-woq96wn","Type":"NodeParagraph","Properties":{"id":"20250915131315-woq96wn","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"甚至更简洁的写法（直接返回TRUE/FALSE）"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-o4ljpla","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-o4ljpla","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=NOT(ISNA(XLOOKUP(A2, Sheet2!$A$2:$A$500, Sheet2!$A$2:$A$500)))\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-wfylpbh","Type":"NodeParagraph","Properties":{"id":"20250915131315-wfylpbh","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-fngpmru","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-fngpmru","updated":"20250915131315"},"Children":[{"ID":"20250915131315-g65296g","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-g65296g","updated":"20250915131315"},"Children":[{"ID":"20250915131315-egtvtma","Type":"NodeParagraph","Properties":{"id":"20250915131315-egtvtma","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"公式更简洁直观。"}]}]},{"ID":"20250915131315-courdwb","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-courdwb","updated":"20250915131315"},"Children":[{"ID":"20250915131315-2b2rdac","Type":"NodeParagraph","Properties":{"id":"20250915131315-2b2rdac","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"计算效率通常比 COUNTIF 和 VLOOKUP 更高。"}]}]}]},{"ID":"20250915131315-r6zkpyg","Type":"NodeParagraph","Properties":{"id":"20250915131315-r6zkpyg","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-g58be3t","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-g58be3t","updated":"20250915131315"},"Children":[{"ID":"20250915131315-skzhdsq","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-skzhdsq","updated":"20250915131315"},"Children":[{"ID":"20250915131315-sep83z3","Type":"NodeParagraph","Properties":{"id":"20250915131315-sep83z3","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"仅适用于较新版本的 Excel。"}]}]}]},{"ID":"20250915131315-lxkcb3a","Type":"NodeThematicBreak","Properties":{"id":"20250915131315-lxkcb3a","updated":"20250915131315"}},{"ID":"20250915131315-et28g2o","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915131315-et28g2o","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"方法四：使用 MATCH 函数（另一种思路）"}]},{"ID":"20250915131315-gasg7r0","Type":"NodeParagraph","Properties":{"id":"20250915131315-gasg7r0","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"MATCH"},{"Type":"NodeText","Data":" 函数用于查找项在范围中的相对位置，找不到则返回错误。其思路和 VLOOKUP 类似。"}]},{"ID":"20250915131315-ar4658z","Type":"NodeParagraph","Properties":{"id":"20250915131315-ar4658z","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"B2"},{"Type":"NodeText","Data":" 单元格输入以下公式，然后向下拖动填充："}]},{"ID":"20250915131315-m1hzz18","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-m1hzz18","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IF(ISNA(MATCH(A2, Sheet2!$A$2:$A$500, 0)), \"不存在\", \"存在\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915131315-rj8740i","Type":"NodeParagraph","Properties":{"id":"20250915131315-rj8740i","updated":"20250915131315"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式解释"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915131315-3ytgktg","Type":"NodeList","ListData":{},"Properties":{"id":"20250915131315-3ytgktg","updated":"20250915131315"},"Children":[{"ID":"20250915131315-8uojj63","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-8uojj63","updated":"20250915131315"},"Children":[{"ID":"20250915131315-fb0usv6","Type":"NodeParagraph","Properties":{"id":"20250915131315-fb0usv6","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"MATCH(A2, Sheet2!$A$2:$A$500, 0)"},{"Type":"NodeText","Data":"：精确查找 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2"},{"Type":"NodeText","Data":" 在参考表中的位置。"}]}]},{"ID":"20250915131315-b72ldvd","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915131315-b72ldvd","updated":"20250915131315"},"Children":[{"ID":"20250915131315-mrcysvq","Type":"NodeParagraph","Properties":{"id":"20250915131315-mrcysvq","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"其余部分同方法二。"}]}]}]},{"ID":"20250915131315-0jgzg4h","Type":"NodeThematicBreak","Properties":{"id":"20250915131315-0jgzg4h","updated":"20250915131315"}},{"ID":"20250915131315-9krrncg","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915131315-9krrncg","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"方法五：条件格式（用于高亮显示）"}]},{"ID":"20250915131315-21n9qx5","Type":"NodeParagraph","Properties":{"id":"20250915131315-21n9qx5","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"如果你的目的不是生成新的一列结果，而是"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"想直观地看到表A中哪些值在表B里存在"},{"Type":"NodeText","Data":"，可以使用条件格式来高亮显示。"}]},{"ID":"20250915131315-0ian3ll","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915131315-0ian3ll","updated":"20250915131315"},"Children":[{"ID":"20250915131315-fz4tbb7","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915131315-fz4tbb7","updated":"20250915131315"},"Children":[{"ID":"20250915131315-83a35gs","Type":"NodeParagraph","Properties":{"id":"20250915131315-83a35gs","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"选中 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Sheet1"},{"Type":"NodeText","Data":" 中你要检查的数据区域（如 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A100"},{"Type":"NodeText","Data":"）。"}]}]},{"ID":"20250915131315-yh5fmqv","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915131315-yh5fmqv","updated":"20250915131315"},"Children":[{"ID":"20250915131315-mbiusgx","Type":"NodeParagraph","Properties":{"id":"20250915131315-mbiusgx","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"点击菜单栏的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“开始”"},{"Type":"NodeText","Data":" -\u003e "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“条件格式”"},{"Type":"NodeText","Data":" -\u003e "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“新建规则”"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915131315-3kas7hq","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915131315-3kas7hq","updated":"20250915131315"},"Children":[{"ID":"20250915131315-rqa1l6r","Type":"NodeParagraph","Properties":{"id":"20250915131315-rqa1l6r","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"选择 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“使用公式确定要设置格式的单元格”"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915131315-vrbalh0","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915131315-vrbalh0","updated":"20250915131315"},"Children":[{"ID":"20250915131315-211e8zv","Type":"NodeParagraph","Properties":{"id":"20250915131315-211e8zv","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"在公式框中输入以下公式："}]},{"ID":"20250915131315-k1uz2wg","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915131315-k1uz2wg","updated":"20250915131315"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=COUNTIF(Sheet2!$A$2:$A$500, A2)\u003e0\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]}]},{"ID":"20250915131315-ubjcokh","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915131315-ubjcokh","updated":"20250915131315"},"Children":[{"ID":"20250915131315-o4d1z4t","Type":"NodeParagraph","Properties":{"id":"20250915131315-o4d1z4t","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"点击 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“格式”"},{"Type":"NodeText","Data":" 按钮，选择一个填充颜色（如绿色）。"}]}]},{"ID":"20250915131315-dt0dpkn","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Ni4=","Num":6},"Properties":{"id":"20250915131315-dt0dpkn","updated":"20250915131315"},"Children":[{"ID":"20250915131315-iietm03","Type":"NodeParagraph","Properties":{"id":"20250915131315-iietm03","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"点击 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“确定”"},{"Type":"NodeText","Data":"。"}]}]}]},{"ID":"20250915131315-geptnbw","Type":"NodeParagraph","Properties":{"id":"20250915131315-geptnbw","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"这样，所有在参考表中存在的值就会被自动高亮显示。"}]},{"ID":"20250915131315-089jghh","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915131315-089jghh","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"总结与推荐"}]},{"ID":"20250915131315-2vi0w5i","Type":"NodeTable","TableAligns":[1,1,1],"Properties":{"colgroup":"||","id":"20250915131315-2vi0w5i","updated":"20250915131315"},"Children":[{"Type":"NodeTableHead","Data":"thead","Children":[{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"方法"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"推荐指数"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"适用场景"}]}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"COUNTIF"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"⭐⭐⭐⭐⭐"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"通用首选"},{"Type":"NodeText","Data":"，兼容所有版本，简单有效"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"XLOOKUP"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"⭐⭐⭐⭐⭐"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Office 365用户首选"},{"Type":"NodeText","Data":"，公式简洁，性能好"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"VLOOKUP / MATCH"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"⭐⭐⭐"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"有效，但公式稍显复杂，是 COUNTIF 的替代方案"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"条件格式"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"⭐⭐⭐⭐"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"不想增加辅助列，只想可视化查看结果时使用"}]}]}]},{"ID":"20250915131315-6kyq219","Type":"NodeParagraph","Properties":{"id":"20250915131315-6kyq219","updated":"20250915131315"},"Children":[{"Type":"NodeText","Data":"对于大多数用户，我首推 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"COUNTIF"},{"Type":"NodeText","Data":" 方法，因为它最直观，适用性最广。"}]},{"ID":"20250915140750-qsgfu19","Type":"NodeParagraph","Properties":{"id":"20250915140750-qsgfu19","updated":"20250915140750"}},{"ID":"20250915140814-61tc7jt","Type":"NodeParagraph","Properties":{"id":"20250915140814-61tc7jt","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"好的，在 Excel 中“只显示不为空的单元格”是一个常见需求，根据您是想"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"永久性地整理数据"},{"Type":"NodeText","Data":"还是"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"临时性地查看数据"},{"Type":"NodeText","Data":"，有以下几种方法。"}]},{"ID":"20250915140814-sxfiqjs","Type":"NodeParagraph","Properties":{"id":"20250915140814-sxfiqjs","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"我将从最简单、最常用的方法开始介绍。"}]},{"ID":"20250915140814-jjc2ioz","Type":"NodeThematicBreak","Properties":{"id":"20250915140814-jjc2ioz","updated":"20250915140814"}},{"ID":"20250915140814-z1x8y69","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915140814-z1x8y69","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"方法一：筛选（Filter） - 最推荐、最快捷"}]},{"ID":"20250915140814-dpd98rq","Type":"NodeParagraph","Properties":{"id":"20250915140814-dpd98rq","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"这是最常用且非破坏性的方法。它只是暂时隐藏空行，不会删除任何数据。"}]},{"ID":"20250915140814-jc5eqfv","Type":"NodeParagraph","Properties":{"id":"20250915140814-jc5eqfv","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"操作步骤："}]},{"ID":"20250915140814-169jylq","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915140814-169jylq","updated":"20250915140814"},"Children":[{"ID":"20250915140814-m3km893","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915140814-m3km893","updated":"20250915140814"},"Children":[{"ID":"20250915140814-0pj9xie","Type":"NodeParagraph","Properties":{"id":"20250915140814-0pj9xie","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"选中您的数据区域（包括标题行）。"}]}]},{"ID":"20250915140814-2hio0nw","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915140814-2hio0nw","updated":"20250915140814"},"Children":[{"ID":"20250915140814-c2300t7","Type":"NodeParagraph","Properties":{"id":"20250915140814-c2300t7","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"点击菜单栏的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“数据”"},{"Type":"NodeText","Data":" (Data) \u003e "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“筛选”"},{"Type":"NodeText","Data":" (Filter)。此时每个标题栏会出现一个小箭头。"}]}]},{"ID":"20250915140814-hxe9z14","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915140814-hxe9z14","updated":"20250915140814"},"Children":[{"ID":"20250915140814-xdx0fyb","Type":"NodeParagraph","Properties":{"id":"20250915140814-xdx0fyb","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"点击您想筛选的那一列标题上的小箭头。"}]}]},{"ID":"20250915140814-3owx962","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915140814-3owx962","updated":"20250915140814"},"Children":[{"ID":"20250915140814-zxk16d9","Type":"NodeParagraph","Properties":{"id":"20250915140814-zxk16d9","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"在弹出的菜单中，"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"取消勾选 “(空白)”"},{"Type":"NodeText","Data":" (Blanks)。"}]}]},{"ID":"20250915140814-ubpqxzm","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915140814-ubpqxzm","updated":"20250915140814"},"Children":[{"ID":"20250915140814-ex4dguh","Type":"NodeParagraph","Properties":{"id":"20250915140814-ex4dguh","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"点击“确定”。"}]}]}]},{"ID":"20250915140814-7vhcywd","Type":"NodeParagraph","Properties":{"id":"20250915140814-7vhcywd","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"效果："},{"Type":"NodeText","Data":" 所有在该列为空的行都会被隐藏起来，只显示有内容的行。"}]},{"ID":"20250915140814-y8q5k1o","Type":"NodeParagraph","Properties":{"id":"20250915140814-y8q5k1o","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"取消筛选："},{"Type":"NodeText","Data":" 再次点击“数据” \u003e “筛选”即可取消，所有数据会重新显示。"}]},{"ID":"20250915140814-vb73rih","Type":"NodeParagraph","Properties":{"id":"20250915140814-vb73rih","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点："},{"Type":"NodeText","Data":" 操作简单，可逆，不影响原始数据。"}]},{"ID":"20250915140814-ie7i7be","Type":"NodeThematicBreak","Properties":{"id":"20250915140814-ie7i7be","updated":"20250915140814"}},{"ID":"20250915140814-d4fb1jm","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915140814-d4fb1jm","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"方法二：排序（Sort）- 让空单元格集中到一起"}]},{"ID":"20250915140814-hoeo7c7","Type":"NodeParagraph","Properties":{"id":"20250915140814-hoeo7c7","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"排序不会隐藏空单元格，但可以将所有非空单元格集中到列表顶部，方便您查看和操作。"}]},{"ID":"20250915140814-zjc80rv","Type":"NodeParagraph","Properties":{"id":"20250915140814-zjc80rv","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"操作步骤："}]},{"ID":"20250915140814-ek4svm2","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915140814-ek4svm2","updated":"20250915140814"},"Children":[{"ID":"20250915140814-mn5qdte","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915140814-mn5qdte","updated":"20250915140814"},"Children":[{"ID":"20250915140814-v4b0thf","Type":"NodeParagraph","Properties":{"id":"20250915140814-v4b0thf","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"选中您要排序的那一列数据（最好选中整个数据表，以免数据错乱）。"}]}]},{"ID":"20250915140814-nfe0qzq","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915140814-nfe0qzq","updated":"20250915140814"},"Children":[{"ID":"20250915140814-1zwnl8q","Type":"NodeParagraph","Properties":{"id":"20250915140814-1zwnl8q","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"点击菜单栏的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“数据”"},{"Type":"NodeText","Data":" (Data) \u003e "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“排序”"},{"Type":"NodeText","Data":" (Sort)。"}]}]},{"ID":"20250915140814-bppb7tj","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915140814-bppb7tj","updated":"20250915140814"},"Children":[{"ID":"20250915140814-2vomfjf","Type":"NodeParagraph","Properties":{"id":"20250915140814-2vomfjf","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"在排序对话框中，主要关键字选择您选中的列，排序依据为“单元格值”，次序选择“升序”或“降序”都可以（因为文本和数字通常会排在空值前面）。"}]}]},{"ID":"20250915140814-srw70cy","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915140814-srw70cy","updated":"20250915140814"},"Children":[{"ID":"20250915140814-f230f0g","Type":"NodeParagraph","Properties":{"id":"20250915140814-f230f0g","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"点击“确定”。"}]}]}]},{"ID":"20250915140814-6s2o766","Type":"NodeParagraph","Properties":{"id":"20250915140814-6s2o766","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"效果："},{"Type":"NodeText","Data":" 所有空单元格会被集中到数据区域的底部（或顶部），非空单元格则排列在一起。"}]},{"ID":"20250915140814-5mn5sbv","Type":"NodeParagraph","Properties":{"id":"20250915140814-5mn5sbv","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点："},{"Type":"NodeText","Data":" 快速将空值和非空值分组，同样不影响原始数据。"}]},{"ID":"20250915140814-r39ydn4","Type":"NodeThematicBreak","Properties":{"id":"20250915140814-r39ydn4","updated":"20250915140814"}},{"ID":"20250915140814-ify0zgn","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915140814-ify0zgn","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"方法三：使用“转到特殊”功能选中并删除整行（永久性删除）"}]},{"ID":"20250915140814-c1n3pap","Type":"NodeParagraph","Properties":{"id":"20250915140814-c1n3pap","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"警告：此方法会永久删除空行，操作前请确保已备份原始数据或确认无误。"}]},{"ID":"20250915140814-w6yymou","Type":"NodeParagraph","Properties":{"id":"20250915140814-w6yymou","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"如果您想直接删除所有空行，可以使用此方法。"}]},{"ID":"20250915140814-rkabb41","Type":"NodeParagraph","Properties":{"id":"20250915140814-rkabb41","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"操作步骤："}]},{"ID":"20250915140814-zpg6m85","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915140814-zpg6m85","updated":"20250915140814"},"Children":[{"ID":"20250915140814-g1fbjb8","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915140814-g1fbjb8","updated":"20250915140814"},"Children":[{"ID":"20250915140814-n67uf6q","Type":"NodeParagraph","Properties":{"id":"20250915140814-n67uf6q","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"选中包含空单元格的列（假设您想根据A列是否为空来删除整行，就选中A列）。"}]}]},{"ID":"20250915140814-onj8nuk","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915140814-onj8nuk","updated":"20250915140814"},"Children":[{"ID":"20250915140814-i940psj","Type":"NodeParagraph","Properties":{"id":"20250915140814-i940psj","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"按下 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"F5"},{"Type":"NodeText","Data":" 键或 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"Ctrl + G"},{"Type":"NodeText","Data":"，打开“定位”对话框。"}]}]},{"ID":"20250915140814-a7l77s1","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915140814-a7l77s1","updated":"20250915140814"},"Children":[{"ID":"20250915140814-9p218sk","Type":"NodeParagraph","Properties":{"id":"20250915140814-9p218sk","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"点击左下角的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“定位条件”"},{"Type":"NodeText","Data":" (Special...)。"}]}]},{"ID":"20250915140814-brzvug8","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NC4=","Num":4},"Properties":{"id":"20250915140814-brzvug8","updated":"20250915140814"},"Children":[{"ID":"20250915140814-80fl7tr","Type":"NodeParagraph","Properties":{"id":"20250915140814-80fl7tr","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"在弹出的窗口中，选择 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“空值”"},{"Type":"NodeText","Data":" (Blanks)，然后点击“确定”。此时所有空单元格都会被选中。"}]}]},{"ID":"20250915140814-dyj4uge","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"NS4=","Num":5},"Properties":{"id":"20250915140814-dyj4uge","updated":"20250915140814"},"Children":[{"ID":"20250915140814-hdikdrl","Type":"NodeParagraph","Properties":{"id":"20250915140814-hdikdrl","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"保持选中状态，在菜单栏右键点击任意一个选中的单元格，选择 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“删除”"},{"Type":"NodeText","Data":" (Delete)。"}]}]},{"ID":"20250915140814-wdk42z4","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Ni4=","Num":6},"Properties":{"id":"20250915140814-wdk42z4","updated":"20250915140814"},"Children":[{"ID":"20250915140814-n2pjrt4","Type":"NodeParagraph","Properties":{"id":"20250915140814-n2pjrt4","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"在弹出的对话框中选择 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“整行”"},{"Type":"NodeText","Data":" (Entire row)，然后点击“确定”。"}]}]}]},{"ID":"20250915140814-5qcs3y8","Type":"NodeParagraph","Properties":{"id":"20250915140814-5qcs3y8","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"效果："},{"Type":"NodeText","Data":" 所有选中的空单元格所在的整行都会被永久删除。"}]},{"ID":"20250915140814-f3qd0ij","Type":"NodeParagraph","Properties":{"id":"20250915140814-f3qd0ij","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点："},{"Type":"NodeText","Data":" 一次性彻底清理空行。\n"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点："},{"Type":"NodeText","Data":" 不可逆，会改变原始数据结构。"}]},{"ID":"20250915140814-czert28","Type":"NodeThematicBreak","Properties":{"id":"20250915140814-czert28","updated":"20250915140814"}},{"ID":"20250915140814-hteniw1","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915140814-hteniw1","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"方法四：使用公式（创建新的无空值列表）"}]},{"ID":"20250915140814-1nj1s5x","Type":"NodeParagraph","Properties":{"id":"20250915140814-1nj1s5x","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"如果您不想改动原表，希望在一个新的地方生成一个自动忽略空值的列表，可以使用公式。"}]},{"ID":"20250915140814-olbee23","Type":"NodeParagraph","Properties":{"id":"20250915140814-olbee23","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"假设原始数据在 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A100"},{"Type":"NodeText","Data":"，您想在C列开始生成新列表。"}]},{"ID":"20250915140814-5tcvmiq","Type":"NodeParagraph","Properties":{"id":"20250915140814-5tcvmiq","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"适用于 Microsoft 365 和 Excel 2021 的公式："}]},{"ID":"20250915140814-g85bdjh","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915140814-g85bdjh","updated":"20250915140814"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=FILTER(A2:A100, A2:A100\u003c\u003e\"\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915140814-y8qvg1e","Type":"NodeParagraph","Properties":{"id":"20250915140814-y8qvg1e","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"这个 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"FILTER"},{"Type":"NodeText","Data":" 函数会动态返回所有不为空的单元格。"}]},{"ID":"20250915140814-r0l4drm","Type":"NodeParagraph","Properties":{"id":"20250915140814-r0l4drm","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"适用于所有Excel版本的通用公式（数组公式）："},{"Type":"NodeText","Data":"\n在C2单元格输入以下公式，然后按 "},{"Type":"NodeTextMark","TextMarkType":"strong code","TextMarkTextContent":"Ctrl + Shift + Enter"},{"Type":"NodeText","Data":" 三键确认（如果是最新版本，按Enter即可），然后向下拖动填充。"}]},{"ID":"20250915140814-2ya5p44","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915140814-2ya5p44","updated":"20250915140814"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IFERROR(INDEX($A$2:$A$100, SMALL(IF($A$2:$A$100\u003c\u003e\"\", ROW($A$2:$A$100)-ROW($A$2)+1), ROWS(C$2:C2))), \"\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915140814-35bk15m","Type":"NodeParagraph","Properties":{"id":"20250915140814-35bk15m","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"效果："},{"Type":"NodeText","Data":" 在新的位置生成一个连续且没有空单元格的列表。"}]},{"ID":"20250915140814-oi93xc9","Type":"NodeParagraph","Properties":{"id":"20250915140814-oi93xc9","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点："},{"Type":"NodeText","Data":" 不改变原始数据，生成动态结果。\n"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点："},{"Type":"NodeText","Data":" 公式较复杂（特别是旧版公式），需要占用新的空间。"}]},{"ID":"20250915140814-oadegm0","Type":"NodeThematicBreak","Properties":{"id":"20250915140814-oadegm0","updated":"20250915140814"}},{"ID":"20250915140814-8hpbfk1","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915140814-8hpbfk1","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"总结与推荐"}]},{"ID":"20250915140814-6wfddgg","Type":"NodeTable","TableAligns":[1,1,1,1],"Properties":{"colgroup":"|||","id":"20250915140814-6wfddgg","updated":"20250915140814"},"Children":[{"Type":"NodeTableHead","Data":"thead","Children":[{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"方法"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"适用场景"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"优点"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"缺点"}]}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"筛选 (Filter)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"临时查看数据"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"简单、快速、可逆"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"只是隐藏，并非真正删除"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"排序 (Sort)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"快速将空值分组"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"简单、可逆"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"不隐藏空值，只是重新排列"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"转到特殊 (Go To Special)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"永久性删除空行"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"彻底清理数据"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"不可逆，会删除数据"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式 (Formula)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"创建新的无空值列表"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"不改变原数据，动态更新"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"需要额外空间，公式可能复杂"}]}]}]},{"ID":"20250915140814-r3fuk3y","Type":"NodeParagraph","Properties":{"id":"20250915140814-r3fuk3y","updated":"20250915140814"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"日常使用中最推荐的顺序是："}]},{"ID":"20250915140814-0rl501l","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915140814-0rl501l","updated":"20250915140814"},"Children":[{"ID":"20250915140814-8t5w6hp","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915140814-8t5w6hp","updated":"20250915140814"},"Children":[{"ID":"20250915140814-n1u6j85","Type":"NodeParagraph","Properties":{"id":"20250915140814-n1u6j85","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"如果想临时看看哪些数据不为空，用 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"筛选"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915140814-vjdci7v","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915140814-vjdci7v","updated":"20250915140814"},"Children":[{"ID":"20250915140814-d97d7dw","Type":"NodeParagraph","Properties":{"id":"20250915140814-d97d7dw","updated":"20250915140814"},"Children":[{"Type":"NodeText","Data":"如果想永久清理数据，用 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"转到特殊"},{"Type":"NodeText","Data":"（务必谨慎！）。"}]}]},{"ID":"20250915140814-1pn5c62","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915140814-1pn5c62","updated":"20250915140814"},"Children":[{"ID":"20250915140814-1s71o21","Type":"NodeParagraph","Properties":{"id":"20250915140814-1s71o21","updated":"20250915141131"},"Children":[{"Type":"NodeText","Data":"如果想在新位置创建一个整洁的列表，用 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"FILTER函数"},{"Type":"NodeText","Data":"（如果是365用户）或传统数组公式。】【"}]}]}]},{"ID":"20250915141131-5wym87f","Type":"NodeParagraph","Properties":{"id":"20250915141131-5wym87f","updated":"20250915141131"}},{"ID":"20250915141133-g316bkl","Type":"NodeParagraph","Properties":{"id":"20250915141133-g316bkl","updated":"20250915141133"}},{"ID":"20250915141136-3835k82","Type":"NodeParagraph","Properties":{"id":"20250915141136-3835k82","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"好的，这个公式是 Excel 中一个非常经典且强大的"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数组公式"},{"Type":"NodeText","Data":"，用于从一个可能包含空单元格的区域中，提取出所有非空值，并生成一个连续且无空值的列表。"}]},{"ID":"20250915141136-71bkmpn","Type":"NodeParagraph","Properties":{"id":"20250915141136-71bkmpn","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"这个公式在 Microsoft 365 的 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"FILTER"},{"Type":"NodeText","Data":" 函数出现之前，是解决此类问题的标准方法。即使现在，对于使用旧版 Excel 的用户来说，它仍然至关重要。"}]},{"ID":"20250915141136-zy51wqg","Type":"NodeParagraph","Properties":{"id":"20250915141136-zy51wqg","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"我们来一步步拆解这个公式："}]},{"ID":"20250915141136-pf1868f","Type":"NodeParagraph","Properties":{"id":"20250915141136-pf1868f","updated":"20250915141136"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"最终目标："},{"Type":"NodeText","Data":" 将 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"$A$2:$A$100"},{"Type":"NodeText","Data":" 区域中的所有非空单元格，按顺序提取到 C 列（从 C2 开始）。"}]},{"ID":"20250915141136-1ef5zhk","Type":"NodeThematicBreak","Properties":{"id":"20250915141136-1ef5zhk","updated":"20250915141136"}},{"ID":"20250915141136-mzh5utr","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915141136-mzh5utr","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"公式拆解"}]},{"ID":"20250915141136-bco22ne","Type":"NodeCodeBlock","IsFencedCodeBlock":true,"Properties":{"id":"20250915141136-bco22ne","updated":"20250915141136"},"Children":[{"Type":"NodeCodeBlockFenceOpenMarker","Data":"```"},{"Type":"NodeCodeBlockFenceInfoMarker","CodeBlockInfo":"ZXhjZWw="},{"Type":"NodeCodeBlockCode","Data":"=IFERROR(INDEX($A$2:$A$100, SMALL(IF($A$2:$A$100\u003c\u003e\"\", ROW($A$2:$A$100)-ROW($A$2)+1), ROWS(C$2:C2))), \"\")\n"},{"Type":"NodeCodeBlockFenceCloseMarker","Data":"```"}]},{"ID":"20250915141136-fo8i9jf","Type":"NodeParagraph","Properties":{"id":"20250915141136-fo8i9jf","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"我们从最内层向外层分解："}]},{"ID":"20250915141136-jeme3lb","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915141136-jeme3lb","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"1. 核心逻辑："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF($A$2:$A$100\u0026lt;\u0026gt;\"\", ...)"},{"Type":"NodeText","Data":""}]},{"ID":"20250915141136-3wsi9i8","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-3wsi9i8","updated":"20250915141136"},"Children":[{"ID":"20250915141136-ljmeyi0","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-ljmeyi0","updated":"20250915141136"},"Children":[{"ID":"20250915141136-v1jhghk","Type":"NodeParagraph","Properties":{"id":"20250915141136-v1jhghk","updated":"20250915141136"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"作用"},{"Type":"NodeText","Data":"：这是一个数组操作。它依次检查区域 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A100"},{"Type":"NodeText","Data":" 中的每一个单元格是否不等于空 ("},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\u0026lt;\u0026gt;\"\""},{"Type":"NodeText","Data":")。"}]}]},{"ID":"20250915141136-sm5i6mr","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-sm5i6mr","updated":"20250915141136"},"Children":[{"ID":"20250915141136-2gjbo0k","Type":"NodeParagraph","Properties":{"id":"20250915141136-2gjbo0k","updated":"20250915141136"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"结果"},{"Type":"NodeText","Data":"：它会返回一个由 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"TRUE"},{"Type":"NodeText","Data":" 和 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"FALSE"},{"Type":"NodeText","Data":" 组成的数组。如果单元格非空，对应位置是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"TRUE"},{"Type":"NodeText","Data":"；如果为空，则是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"FALSE"},{"Type":"NodeText","Data":"。"}]},{"ID":"20250915141136-x99f9rq","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-x99f9rq","updated":"20250915141136"},"Children":[{"ID":"20250915141136-g0oci1z","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-g0oci1z","updated":"20250915141136"},"Children":[{"ID":"20250915141136-bkdut6l","Type":"NodeParagraph","Properties":{"id":"20250915141136-bkdut6l","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"例如，如果 A2 有值，A3 为空，A4 有值，则返回 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"{TRUE; FALSE; TRUE; ...}"},{"Type":"NodeText","Data":"。"}]}]}]}]}]},{"ID":"20250915141136-ngjvgoo","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915141136-ngjvgoo","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"2. 生成位置索引："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROW($A$2:$A$100)-ROW($A$2)+1"},{"Type":"NodeText","Data":""}]},{"ID":"20250915141136-0v2b1m9","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-0v2b1m9","updated":"20250915141136"},"Children":[{"ID":"20250915141136-rv4ofrd","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-rv4ofrd","updated":"20250915141136"},"Children":[{"ID":"20250915141136-od8ko7b","Type":"NodeParagraph","Properties":{"id":"20250915141136-od8ko7b","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROW($A$2:$A$100)"},{"Type":"NodeText","Data":"：获取区域 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A100"},{"Type":"NodeText","Data":" 中每个单元格的实际行号，返回一个数组 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"{2;3;4;5;...;100}"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-y1h0wo1","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-y1h0wo1","updated":"20250915141136"},"Children":[{"ID":"20250915141136-52k332g","Type":"NodeParagraph","Properties":{"id":"20250915141136-52k332g","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROW($A$2)"},{"Type":"NodeText","Data":"：获取起始单元格 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2"},{"Type":"NodeText","Data":" 的行号，结果是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"2"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-it9goid","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-it9goid","updated":"20250915141136"},"Children":[{"ID":"20250915141136-jyzbro5","Type":"NodeParagraph","Properties":{"id":"20250915141136-jyzbro5","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROW(...) - ROW($A$2) + 1"},{"Type":"NodeText","Data":"：用每个单元格的实际行号减去起始行号，再加 1。这一步是为了"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"将行号转换为相对于区域起始位置（A2）的索引序号"},{"Type":"NodeText","Data":"。"}]},{"ID":"20250915141136-phd6gxj","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-phd6gxj","updated":"20250915141136"},"Children":[{"ID":"20250915141136-q6z5o5v","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-q6z5o5v","updated":"20250915141136"},"Children":[{"ID":"20250915141136-8rehdtj","Type":"NodeParagraph","Properties":{"id":"20250915141136-8rehdtj","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"结果会是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"{1;2;3;4;...;99}"},{"Type":"NodeText","Data":"。A2 是第 1 个，A3 是第 2 个，A100 是第 99 个。"}]}]}]}]}]},{"ID":"20250915141136-gbzr7qn","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915141136-gbzr7qn","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"3. 结合IF，生成有效值的索引数组："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF($A$2:$A$100\u0026lt;\u0026gt;\"\", ROW(...)-ROW($A$2)+1)"},{"Type":"NodeText","Data":""}]},{"ID":"20250915141136-4fcjjbq","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-4fcjjbq","updated":"20250915141136"},"Children":[{"ID":"20250915141136-kly2j3t","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-kly2j3t","updated":"20250915141136"},"Children":[{"ID":"20250915141136-77oiid6","Type":"NodeParagraph","Properties":{"id":"20250915141136-77oiid6","updated":"20250915141136"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"作用"},{"Type":"NodeText","Data":"：将第1步和第2步结合起来。IF 函数会判断：如果单元格非空（为TRUE），则返回其对应的索引序号；如果为空（为FALSE），则返回 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"FALSE"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-0p0d98m","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-0p0d98m","updated":"20250915141136"},"Children":[{"ID":"20250915141136-bpvwajb","Type":"NodeParagraph","Properties":{"id":"20250915141136-bpvwajb","updated":"20250915141136"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"结果"},{"Type":"NodeText","Data":"：得到一个由"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"索引序号"},{"Type":"NodeText","Data":"和"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"FALSE"},{"Type":"NodeText","Data":"混合的数组。"}]},{"ID":"20250915141136-3ejzzm9","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-3ejzzm9","updated":"20250915141136"},"Children":[{"ID":"20250915141136-ngwkctp","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-ngwkctp","updated":"20250915141136"},"Children":[{"ID":"20250915141136-zo5kp6b","Type":"NodeParagraph","Properties":{"id":"20250915141136-zo5kp6b","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"接上面的例子，结果可能是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"{1; FALSE; 3; ...}"},{"Type":"NodeText","Data":"。这意味着第一个有效值在区域中的位置是1，第二个有效值的位置是3。"}]}]}]}]}]},{"ID":"20250915141136-u9l56jb","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915141136-u9l56jb","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"4. 提取第K个有效值的位置："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"SMALL(..., ROWS(C$2:C2))"},{"Type":"NodeText","Data":""}]},{"ID":"20250915141136-wk6zze8","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-wk6zze8","updated":"20250915141136"},"Children":[{"ID":"20250915141136-fmzaux3","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-fmzaux3","updated":"20250915141136"},"Children":[{"ID":"20250915141136-x2p79zc","Type":"NodeParagraph","Properties":{"id":"20250915141136-x2p79zc","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROWS(C$2:C2)"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915141136-dle6j2u","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-dle6j2u","updated":"20250915141136"},"Children":[{"ID":"20250915141136-jg85m6z","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-jg85m6z","updated":"20250915141136"},"Children":[{"ID":"20250915141136-pxw42rx","Type":"NodeParagraph","Properties":{"id":"20250915141136-pxw42rx","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"这是一个非常巧妙的设计。"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROWS"},{"Type":"NodeText","Data":" 函数计算从 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"C$2"},{"Type":"NodeText","Data":" 到 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"C2"},{"Type":"NodeText","Data":" 这个区域的行数。"}]}]},{"ID":"20250915141136-ydbylls","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-ydbylls","updated":"20250915141136"},"Children":[{"ID":"20250915141136-93tty7x","Type":"NodeParagraph","Properties":{"id":"20250915141136-93tty7x","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"当公式在 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"C2"},{"Type":"NodeText","Data":" 单元格时，"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROWS(C$2:C2)"},{"Type":"NodeText","Data":" 计算的是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"C2:C2"},{"Type":"NodeText","Data":" 的行数，结果为 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"1"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-mv7c490","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-mv7c490","updated":"20250915141136"},"Children":[{"ID":"20250915141136-0xi684h","Type":"NodeParagraph","Properties":{"id":"20250915141136-0xi684h","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"当公式向下拖动到 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"C3"},{"Type":"NodeText","Data":" 单元格时，引用自动变为 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROWS(C$2:C3)"},{"Type":"NodeText","Data":"，计算 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"C2:C3"},{"Type":"NodeText","Data":" 的行数，结果为 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"2"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-5p00c2p","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-5p00c2p","updated":"20250915141136"},"Children":[{"ID":"20250915141136-od3v2mg","Type":"NodeParagraph","Properties":{"id":"20250915141136-od3v2mg","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"以此类推。这个部分的作用就是"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"生成一个自动递增的计数器 k"},{"Type":"NodeText","Data":"。"}]}]}]}]},{"ID":"20250915141136-yvrfb0h","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-yvrfb0h","updated":"20250915141136"},"Children":[{"ID":"20250915141136-h54gfn4","Type":"NodeParagraph","Properties":{"id":"20250915141136-h54gfn4","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"SMALL(数组, k)"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915141136-d0eiesm","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-d0eiesm","updated":"20250915141136"},"Children":[{"ID":"20250915141136-xf115td","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-xf115td","updated":"20250915141136"},"Children":[{"ID":"20250915141136-sqhbbsx","Type":"NodeParagraph","Properties":{"id":"20250915141136-sqhbbsx","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"这个函数的作用是返回指定"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数组"},{"Type":"NodeText","Data":"中第 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"k"},{"Type":"NodeText","Data":" 个"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"最小值"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-webbhwc","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-webbhwc","updated":"20250915141136"},"Children":[{"ID":"20250915141136-pkckmfz","Type":"NodeParagraph","Properties":{"id":"20250915141136-pkckmfz","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"它会忽略数组中的逻辑值 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"FALSE"},{"Type":"NodeText","Data":" 和错误值。"}]}]},{"ID":"20250915141136-08ky03k","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-08ky03k","updated":"20250915141136"},"Children":[{"ID":"20250915141136-9unz8cc","Type":"NodeParagraph","Properties":{"id":"20250915141136-9unz8cc","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"所以，"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"SMALL({1; FALSE; 3; ...}, 1)"},{"Type":"NodeText","Data":" 会从 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"{1, 3, ...}"},{"Type":"NodeText","Data":" 中找出第1小的数字，即 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"1"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-qcpe03a","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-qcpe03a","updated":"20250915141136"},"Children":[{"ID":"20250915141136-tkifpac","Type":"NodeParagraph","Properties":{"id":"20250915141136-tkifpac","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"在 C3 单元格，公式变为 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"SMALL({1; FALSE; 3; ...}, 2)"},{"Type":"NodeText","Data":"，会找出第2小的数字，即 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"3"},{"Type":"NodeText","Data":"。"}]}]}]}]}]},{"ID":"20250915141136-v03ayc3","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915141136-v03ayc3","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"5. 根据位置索引取值："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"INDEX($A$2:$A$100, ...)"},{"Type":"NodeText","Data":""}]},{"ID":"20250915141136-79t9yyz","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-79t9yyz","updated":"20250915141136"},"Children":[{"ID":"20250915141136-hnmrm3w","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-hnmrm3w","updated":"20250915141136"},"Children":[{"ID":"20250915141136-tjjembc","Type":"NodeParagraph","Properties":{"id":"20250915141136-tjjembc","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"INDEX(区域, 行号)"},{"Type":"NodeText","Data":"：从指定区域（"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2:A100"},{"Type":"NodeText","Data":"）中，返回给定行号的值。"}]}]},{"ID":"20250915141136-2w05uhs","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-2w05uhs","updated":"20250915141136"},"Children":[{"ID":"20250915141136-dkprqa7","Type":"NodeParagraph","Properties":{"id":"20250915141136-dkprqa7","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"接上例，在 C2 单元格，"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"INDEX($A$2:$A$100, 1)"},{"Type":"NodeText","Data":" 返回的是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A2"},{"Type":"NodeText","Data":" 的值。"}]}]},{"ID":"20250915141136-v7j1ilx","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-v7j1ilx","updated":"20250915141136"},"Children":[{"ID":"20250915141136-vqz3gfk","Type":"NodeParagraph","Properties":{"id":"20250915141136-vqz3gfk","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"在 C3 单元格，"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"INDEX($A$2:$A$100, 3)"},{"Type":"NodeText","Data":" 返回的是 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"A4"},{"Type":"NodeText","Data":" 的值。"}]}]}]},{"ID":"20250915141136-b227aic","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915141136-b227aic","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"6. 容错处理："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IFERROR(..., \"\")"},{"Type":"NodeText","Data":""}]},{"ID":"20250915141136-fi6xay5","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-fi6xay5","updated":"20250915141136"},"Children":[{"ID":"20250915141136-tg072md","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-tg072md","updated":"20250915141136"},"Children":[{"ID":"20250915141136-8yb327x","Type":"NodeParagraph","Properties":{"id":"20250915141136-8yb327x","updated":"20250915141136"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"作用"},{"Type":"NodeText","Data":"：当公式拖动到超过非空单元格数量时（比如，原区域只有10个非空值，但你拖动了20行），"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"SMALL"},{"Type":"NodeText","Data":" 函数会找不到第11个最小值，从而返回 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#NUM!"},{"Type":"NodeText","Data":" 错误。"}]}]},{"ID":"20250915141136-5cray9h","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-5cray9h","updated":"20250915141136"},"Children":[{"ID":"20250915141136-nyt1i3a","Type":"NodeParagraph","Properties":{"id":"20250915141136-nyt1i3a","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IFERROR"},{"Type":"NodeText","Data":" 会捕获这个错误，并将其显示为空字符串 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\"\""},{"Type":"NodeText","Data":"，让表格看起来更整洁。"}]}]}]},{"ID":"20250915141136-eeo3wne","Type":"NodeThematicBreak","Properties":{"id":"20250915141136-eeo3wne","updated":"20250915141136"}},{"ID":"20250915141136-8x7zoo6","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915141136-8x7zoo6","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"如何使用这个公式"}]},{"ID":"20250915141136-227i0xa","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915141136-227i0xa","updated":"20250915141136"},"Children":[{"ID":"20250915141136-vdrzwep","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915141136-vdrzwep","updated":"20250915141136"},"Children":[{"ID":"20250915141136-3yan38s","Type":"NodeParagraph","Properties":{"id":"20250915141136-3yan38s","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"在目标单元格（例如 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"C2"},{"Type":"NodeText","Data":"）中输入整个公式。"}]}]},{"ID":"20250915141136-zsn8eh6","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915141136-zsn8eh6","updated":"20250915141136"},"Children":[{"ID":"20250915141136-brr1u8w","Type":"NodeParagraph","Properties":{"id":"20250915141136-brr1u8w","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"对于旧版 Excel（2019及更早版本），必须按 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Ctrl + Shift + Enter"},{"Type":"NodeText","Data":" 来确认输入。如果输入成功，Excel 会在公式两边自动加上大括号 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"{ }"},{"Type":"NodeText","Data":"（"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"注意：不要手动输入它们"},{"Type":"NodeText","Data":"）。"}]}]},{"ID":"20250915141136-0m43cra","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20250915141136-0m43cra","updated":"20250915141136"},"Children":[{"ID":"20250915141136-ntscez7","Type":"NodeParagraph","Properties":{"id":"20250915141136-ntscez7","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"然后将公式向下拖动填充，直到出现一片空白，这意味着所有非空值都已提取完毕。"}]}]}]},{"ID":"20250915141136-qhnlosv","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915141136-qhnlosv","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"总结"}]},{"ID":"20250915141136-g0ww9k9","Type":"NodeParagraph","Properties":{"id":"20250915141136-g0ww9k9","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"这个公式的精妙之处在于它巧妙地组合了多个函数："}]},{"ID":"20250915141136-oqf77ge","Type":"NodeList","ListData":{},"Properties":{"id":"20250915141136-oqf77ge","updated":"20250915141136"},"Children":[{"ID":"20250915141136-hlwp90x","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-hlwp90x","updated":"20250915141136"},"Children":[{"ID":"20250915141136-iaxvv6i","Type":"NodeParagraph","Properties":{"id":"20250915141136-iaxvv6i","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF"},{"Type":"NodeText","Data":" 和 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\u0026lt;\u0026gt;\"\""},{"Type":"NodeText","Data":" 用于"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"识别"},{"Type":"NodeText","Data":"非空单元格。"}]}]},{"ID":"20250915141136-fhif3if","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-fhif3if","updated":"20250915141136"},"Children":[{"ID":"20250915141136-wz605l5","Type":"NodeParagraph","Properties":{"id":"20250915141136-wz605l5","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROW"},{"Type":"NodeText","Data":" 和数学运算用于"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"生成位置索引"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20250915141136-h4752aa","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-h4752aa","updated":"20250915141136"},"Children":[{"ID":"20250915141136-bccd7vj","Type":"NodeParagraph","Properties":{"id":"20250915141136-bccd7vj","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"SMALL"},{"Type":"NodeText","Data":" 和 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"ROWS"},{"Type":"NodeText","Data":" 用于"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"动态排序"},{"Type":"NodeText","Data":"并依次提取第1、2、3...个有效位置。"}]}]},{"ID":"20250915141136-96h6xlk","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-96h6xlk","updated":"20250915141136"},"Children":[{"ID":"20250915141136-3gpkxxn","Type":"NodeParagraph","Properties":{"id":"20250915141136-3gpkxxn","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"INDEX"},{"Type":"NodeText","Data":" 根据位置"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"取出"},{"Type":"NodeText","Data":"实际的值。"}]}]},{"ID":"20250915141136-n67tbj2","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915141136-n67tbj2","updated":"20250915141136"},"Children":[{"ID":"20250915141136-tp0q93k","Type":"NodeParagraph","Properties":{"id":"20250915141136-tp0q93k","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IFERROR"},{"Type":"NodeText","Data":" 用于"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优雅地处理错误"},{"Type":"NodeText","Data":"。"}]}]}]},{"ID":"20250915141136-p8th303","Type":"NodeParagraph","Properties":{"id":"20250915141136-p8th303","updated":"20250915141136"},"Children":[{"Type":"NodeText","Data":"虽然 Microsoft 365 的 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"=FILTER(A2:A100, A2:A100\u0026lt;\u0026gt;\"\")"},{"Type":"NodeText","Data":" 让这个过程变得极其简单，但理解这个经典公式对于深入掌握 Excel 的数组逻辑和函数嵌套非常有帮助。"}]},{"ID":"20250915153107-395sggx","Type":"NodeParagraph","Properties":{"id":"20250915153107-395sggx","updated":"20250915153107"}},{"ID":"20250915153324-8co9usc","Type":"NodeParagraph","Properties":{"id":"20250915153324-8co9usc","updated":"20250915153324"}},{"ID":"20250915153326-iznqf6x","Type":"NodeParagraph","Properties":{"id":"20250915153326-iznqf6x","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"好的，Microsoft Access 是一个非常经典的桌面级关系型数据库，但它确实有一些局限性，比如并发性能弱、难以进行网络协作、费用高（属于Office套件）等。寻找替代品时，我们需要根据您的具体需求来选择。"}]},{"ID":"20250915153326-1ccj0ek","Type":"NodeParagraph","Properties":{"id":"20250915153326-1ccj0ek","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"以下是 Access 的主要替代方案，我将它们分为几类，并说明其优缺点，帮助您做出选择。"}]},{"ID":"20250915153326-67qgjtd","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915153326-67qgjtd","updated":"20250916154053"},"Children":[{"Type":"NodeText","Data":"一、最适合大多数前 Access 用户的替代品（平滑过渡）"}]},{"ID":"20250915153326-hfpu29n","Type":"NodeParagraph","Properties":{"id":"20250915153326-hfpu29n","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"这类工具平衡了易用性和功能，是大多数人和团队从 Access 升级的首选。"}]},{"ID":"20250915153326-8w5gpf4","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20250915153326-8w5gpf4","updated":"20250916154053"},"Children":[{"Type":"NodeText","Data":"1. LibreOffice Base"}]},{"ID":"20250915153326-zre2wpb","Type":"NodeList","ListData":{},"Properties":{"id":"20250915153326-zre2wpb","updated":"20250915153326"},"Children":[{"ID":"20250915153326-r9mg7qt","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-r9mg7qt","updated":"20250915153326"},"Children":[{"ID":"20250915153326-5pll2ke","Type":"NodeParagraph","Properties":{"id":"20250915153326-5pll2ke","updated":"20250915153326"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"类型"},{"Type":"NodeText","Data":"：开源、免费、桌面数据库"}]}]},{"ID":"20250915153326-nogoofd","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-nogoofd","updated":"20250915153326"},"Children":[{"ID":"20250915153326-1jd1m27","Type":"NodeParagraph","Properties":{"id":"20250915153326-1jd1m27","updated":"20250915153326"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"简介"},{"Type":"NodeText","Data":"：LibreOffice 套件的一部分，是 Access 最直接的免费克隆。它提供图形化界面来创建表、表单、查询和报告。"}]}]},{"ID":"20250915153326-ojoy8hk","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-ojoy8hk","updated":"20250915153326"},"Children":[{"ID":"20250915153326-wkm6ep2","Type":"NodeParagraph","Properties":{"id":"20250915153326-wkm6ep2","updated":"20250915153326"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915153326-dk7clz2","Type":"NodeList","ListData":{},"Properties":{"id":"20250915153326-dk7clz2","updated":"20250915153326"},"Children":[{"ID":"20250915153326-h35afff","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-h35afff","updated":"20250915153326"},"Children":[{"ID":"20250915153326-69tbv53","Type":"NodeParagraph","Properties":{"id":"20250915153326-69tbv53","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"完全免费开源。"}]}]},{"ID":"20250915153326-4pwqrd0","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-4pwqrd0","updated":"20250915153326"},"Children":[{"ID":"20250915153326-6key7zm","Type":"NodeParagraph","Properties":{"id":"20250915153326-6key7zm","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"界面和操作逻辑与 Access 非常相似，学习成本低。"}]}]},{"ID":"20250915153326-fyacnp9","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-fyacnp9","updated":"20250915153326"},"Children":[{"ID":"20250915153326-evaprgn","Type":"NodeParagraph","Properties":{"id":"20250915153326-evaprgn","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"使用内置的 HSQLDB 引擎，也支持连接外部数据库（如MySQL, PostgreSQL）。"}]}]}]}]},{"ID":"20250915153326-p4s3d6k","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-p4s3d6k","updated":"20250915153326"},"Children":[{"ID":"20250915153326-ynidvzu","Type":"NodeParagraph","Properties":{"id":"20250915153326-ynidvzu","updated":"20250915153326"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"缺点"},{"Type":"NodeText","Data":"："}]},{"ID":"20250915153326-94pxhww","Type":"NodeList","ListData":{},"Properties":{"id":"20250915153326-94pxhww","updated":"20250915153326"},"Children":[{"ID":"20250915153326-4mhiwlp","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-4mhiwlp","updated":"20250915153326"},"Children":[{"ID":"20250915153326-6zkec13","Type":"NodeParagraph","Properties":{"id":"20250915153326-6zkec13","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"功能和社区生态不如 Access 丰富。"}]}]},{"ID":"20250915153326-zr2j3r4","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-zr2j3r4","updated":"20250915153326"},"Children":[{"ID":"20250915153326-h09auz8","Type":"NodeParagraph","Properties":{"id":"20250915153326-h09auz8","updated":"20250915153326"},"Children":[{"Type":"NodeText","Data":"在处理非常大或复杂的数据时可能也会遇到性能瓶颈。"}]}]}]}]},{"ID":"20250915153326-k0umsb7","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250915153326-k0umsb7","updated":"20250915153326"},"Children":[{"ID":"20250915153326-vvsk0fi","Type":"NodeParagraph","Properties":{"id":"20250915153326-vvsk0fi","updated":"20250915153326"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"适合人群"},{"Type":"NodeText","Data":"：寻找免费、单机、且与 Access 体验最接近的用户"}]}]}]},{"ID":"20250916154053-5brxpyu","Type":"NodeParagraph","Properties":{"id":"20250916154053-5brxpyu","updated":"20250916154053"}}]} |