Skip to content
cccskills
FreePublished on GitHub

spreadsheet-formula-helper

Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil
Works withGoogle SheetsExcel
See how to install

Files included (1)

  • SKILL.md1.3 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Spreadsheet Formula Helper

Produce reliable spreadsheet formulas with explanations.

Inputs to gather

  • Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?).
  • Provide small example rows and the desired result for them.

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.

Output

  • Primary formula, short explanation, and a 2–3 row worked example showing inputs → outputs.
  • Optional: quick troubleshooting checklist for common errors.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

-21risk-automation

Free

Automate 21risk tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil3Updated Jun 24, 2026

-2chat-automation

Free

Automate 2chat tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil3Updated Jun 24, 2026

ably-automation

Free

Automate Ably tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil3Updated Jun 24, 2026

abstract-automation

Free

Automate Abstract tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil3Updated Jun 24, 2026

abuselpdb-automation

Free

Automate Abuselpdb tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil3Updated Jun 24, 2026

abyssale-automation

Free

Automate Abyssale tasks via Rube MCP (Composio). Always search tools first for current schemas.

The English summary is being prepared. Showing the original description.

q2805187159/Anvil3Updated Jun 24, 2026

See all skills by q2805187159

Report a problem with this skill