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.

Schreiben und Debuggen von Tabellenkalkulationsformeln (Excel/Google Sheets), Pivot-Tabellen und Array-Formeln; zwischen Dialekten übersetzen; Wird verwendet, wenn Benutzer Arbeitsformeln mit Beispielen und Randfallprüfungen benötigen. Quelle: composiohq/awesome-codex-skills.

Original anzeigen