Practical workflows for building, fixing and understanding Excel formulas and functions with tested ChatGPT prompts.
Replace fragile VLOOKUP references with XLOOKUP. Get a tested ChatGPT prompt for your exact data layout.
Read workflow →Sum by region, product, date range and more. Use a tested ChatGPT prompt to build the multi-condition SUMIFS formula.
Read workflow →Diagnose manual calculation mode, stale external workbook links, and circular totals with three tested prompts.
Read workflow →Restore calculated results when Excel displays formula text because of Show Formulas mode, Text formatting, or a leading apostrophe.
Read workflow →Find exact matches, return values missing from one list, and reconcile duplicate occurrences with tested formulas.
Read workflow →Compare matching cells, reconcile reordered records by ID, and audit formula differences with tested prompts.
Read workflow →Highlight every duplicate, only repeats after the first, or entire rows based on a complete multi-column key.
Read workflow →Grade bands, pay tiers, conditional flags. Get a tested ChatGPT prompt for nested IF logic without the headache.
Read workflow →Build reusable custom functions without VBA. Use a tested ChatGPT prompt to write and name your LAMBDA from scratch.
Read workflow →Inherited a formula nobody can explain? Use ChatGPT to break it down layer by layer.
Read workflow →Highlight entire rows, fix mixed references, and combine multiple conditions with tested ChatGPT prompts.
Read workflow →Check for a word or string with SEARCH or FIND, return a flag with IF, and count matching cells with COUNTIF wildcards.
Read workflow →Build exact lookups with two or three criteria, audit helper keys, support legacy arrays, and detect multiple matching rows.
Read workflow →