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。

查看原文