agentsclimarketplace
Sign in

Excel data processing

Skill cxcscmu/SkillLearnBench/skills/b4-skill-creator-gemini-3.1-flash-lite-preview/weighted-gdp-calculation/excel-data-processing

How to perform data lookups in Excel using INDEX and MATCH. Use this skill when needing to extract data from a source table based on two conditions (e.g., Row header and Column header).From its SKILL.md

Install
npx -y skills add cxcscmu/SkillLearnBench --skill excel-data-processing

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

0.8 KB, 150 tokens by cl100k_base, as published. Nobody here has run it

Excel Data Processing: INDEX & MATCH

Use the following pattern to perform a 2D lookup:

=INDEX(data_range, MATCH(row_lookup, row_range, 0), MATCH(col_lookup, col_range, 0))

  • data_range: The grid containing the source data.
  • row_lookup: The criteria for the row (e.g., Series Code).
  • row_range: The column header or range containing the series codes.
  • col_lookup: The criteria for the column (e.g., Year).
  • col_range: The row header or range containing the years.

Ensure all ranges are locked using $ signs (e.g., $D$21:$Z$40) when referencing fixed data tables.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.