Skip to content
cccskills
FreePublished on GitHub

spreadsheet-formula-helper

Create and debug formulas for Excel and Google Sheets, including formulas that return multiple results. Get placement instructions, worked examples, checks for blanks and duplicates, and equivalent formulas when moving between platforms.

OriginalShow the original description

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.

See how to install

Good for

  • Create formulas from sample data and expected results
  • Fix errors caused by blanks or duplicate values
  • Convert formulas between Excel and Google Sheets
  • Build array formulas and pivot tables

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

Automate 21risk operations through Rube MCP, a connection for agent tools. The skill discovers available actions, checks the service connection, and uses current input requirements to carry out requested tasks.

  • Find available 21risk actions
  • Run tasks after checking the service connection
  • Process multiple operations in bulk
composio-community/awesome-codex-skills17KUpdated Jul 26, 2026

Automate supported 2chat tasks through Rube MCP and Composio. The skill finds available tools, checks the service connection, and uses current input requirements to carry out the requested operations.

  • Find tools for a 2chat task
  • Check the 2chat connection before running tasks
  • Run multiple supported operations together
composio-community/awesome-codex-skills17KUpdated Jul 26, 2026

ably-automation

FreeSummary

Automate Ably operations through Rube MCP and Composio. The skill discovers tools for your task, checks current input requirements, verifies an active connection, and guides execution of single operations or batches.

  • Discover available tools for an Ably task
  • Check the Ably connection before execution
  • Run multiple Ably operations together
composio-community/awesome-codex-skills17KUpdated Jul 26, 2026

Automate Abstract tasks using Rube MCP, a connection for agent tools. The skill searches for available operations, confirms an active service connection, and runs actions according to their current input requirements.

  • Discovering supported Abstract operations
  • Executing Abstract tasks through an agent
  • Fetching all pages of a tool response
composio-community/awesome-codex-skills17KUpdated Jul 26, 2026

Automate Abuselpdb operations through Rube MCP, a connection for agent tools. Discover available actions and their required inputs, verify the service connection, and execute tasks using the current tool definitions.

  • Finding available Abuselpdb actions
  • Checking the connection before running tasks
  • Automating repeated Abuselpdb operations
composio-community/awesome-codex-skills17KUpdated Jul 26, 2026

Automate Abyssale operations through Rube MCP, a connection for agent tools. The skill discovers available actions and their current input requirements, checks the service connection, and executes the tools returned by the search.

  • Discovering available Abyssale operations
  • Checking the Abyssale connection before execution
  • Running Abyssale operations through an agent
composio-community/awesome-codex-skills17KUpdated Jul 26, 2026

See all skills by composio-community

Report a problem with this skill