spreadsheet-formula-helper

SKILL.md

Workflow 1) Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify. 2) Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.

3) Explain how it works and where to place it; include named ranges if helpful. 4) Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g., IFERROR, LET, LAMBDA).

5) Variants: if porting between Excel and Sheets, provide both versions.

编写和调试电子表格公式（Excel/Google Sheets）、数据透视表和数组公式；方言之间的翻译；当用户需要带有示例和边缘情况检查的工作公式时使用。 来源：composiohq/awesome-codex-skills。

查看原文