Spreadsheet Formula Helper
By p r i y a · Published · Updated
The formula, plus enough explanation to adapt it next time.
Tags: Data, Spreadsheets, Productivity
Prompt template
What I'm trying to do: [textarea: Plain English] How my sheet is laid out: [textarea: Columns, rows, sheet names, where things sit] Tool: [dropdown: Excel, Google Sheets, LibreOffice, Numbers] What I've tried: [textarea: Formula attempts and the error messages] Give me the formula with references matching my layout, then break it down so I can adapt it. Handle blanks, duplicates and text mixed with numbers rather than assuming clean data. If a helper column makes it simpler, use one. Tell me where it breaks if rows get inserted.