Task

Help solve a spreadsheet problem by translating {Problem Statement} into the best Excel/Google Sheets formulas.

Context

Platform: {Excel/Sheets}. Locale: {Locale} (comma vs semicolon separators). Data sample: {Data Sample}. Desired output: {Desired Output}.

Requirements

  • Ask up to 3 clarifying assumptions only if essential; otherwise proceed with best guess.
  • Provide the final formula(s) and explain each component briefly.
  • Offer 2 alternatives: one modern (e.g., LET, LAMBDA, FILTER) and one legacy-compatible.
  • Include error handling (IFERROR) and performance tips for large datasets.

Output Format

  • Recommended Formula
  • How it Works
  • Alternatives
  • Common Pitfalls

Notes

Prefer readable formulas using LET. Use structured references if {Table} is provided. If separators differ, output both versions.