Formula Fixer
Short, tested guides to the spreadsheet formulas people search for most, with examples that work in both Excel and Google Sheets unless noted.
Latest guides
- Print Christmas Card Address Labels From Excel or Google Sheets (Mail Merge)
- Pivot Tables in Excel and Google Sheets: A Beginner's Guide With Examples
- Secret Santa Generator in Excel and Google Sheets (Free Formula, No Self-Picks)
- How to Create a Drop-Down List in Excel and Google Sheets (Step by Step)
Print Christmas Card Address Labels From Excel or Google Sheets (Mail Merge)
Turn your Christmas card list into printed address labels: how to set up the spreadsheet, the Word mail merge steps for Avery-style labels, a Google Sheets route, formulas for 'The Smith Family' lines and fixes for common problems.
Turn your Christmas card list into printed address labels: how to set up the spreadsheet, the Word mail merge steps for Avery-style labels, a Google Sheets route, formulas for 'The Smith Family' lines and fixes for common problems.
Pivot Tables in Excel and Google Sheets: A Beginner's Guide With Examples
What a pivot table does, how to make one in Excel and in Google Sheets step by step, the four field areas explained, how to group dates by month, show percentages, refresh, and fix the most common mistakes.
What a pivot table does, how to make one in Excel and in Google Sheets step by step, the four field areas explained, how to group dates by month, show percentages, refresh, and fix the most common mistakes.
Secret Santa Generator in Excel and Google Sheets (Free Formula, No Self-Picks)
Draw Secret Santa names in Excel or Google Sheets with one shuffle formula that never lets anyone pick themselves. Step-by-step formulas, a check that the draw is valid, how to keep couples apart, how to freeze the result and how to send matches privately.
Draw Secret Santa names in Excel or Google Sheets with one shuffle formula that never lets anyone pick themselves. Step-by-step formulas, a check that the draw is valid, how to keep couples apart, how to freeze the result and how to send matches privately.
How to Create a Drop-Down List in Excel and Google Sheets (Step by Step)
Add a drop-down list in Excel with Data Validation or in Google Sheets with Insert > Dropdown. Typed lists, lists from a range, lists that grow automatically, dependent drop-downs, colours, multiple selections and how to fix a drop-down that is not working.
Add a drop-down list in Excel with Data Validation or in Google Sheets with Insert > Dropdown. Typed lists, lists from a range, lists that grow automatically, dependent drop-downs, colours, multiple selections and how to fix a drop-down that is not working.
Black Friday 2026 Deal Tracker Spreadsheet: Formulas to Spot Real Deals
Black Friday is 27 November 2026 and Cyber Monday is 30 November. Build a deal tracker in Excel or Google Sheets that compares stores, shows the real percent off, flags fake discounts against the 30-day low and keeps you on budget.
Black Friday is 27 November 2026 and Cyber Monday is 30 November. Build a deal tracker in Excel or Google Sheets that compares stores, shows the real percent off, flags fake discounts against the 30-day low and keeps you on budget.
FILTER Function in Excel and Google Sheets: Multiple Conditions, Errors and Examples
How FILTER returns every matching row with one formula: syntax, AND and OR conditions, text and date filters, combining with SORT and UNIQUE, the differences between Excel and Google Sheets, and how to fix #CALC!, #SPILL! and #N/A.
How FILTER returns every matching row with one formula: syntax, AND and OR conditions, text and date filters, combining with SORT and UNIQUE, the differences between Excel and Google Sheets, and how to fix #CALC!, #SPILL! and #N/A.
Christmas Budget Tracker in Excel or Google Sheets: Formulas to Stay on Budget
Build a holiday gift budget spreadsheet in 10 minutes: spend per person with SUMIFS, money left, percent used, Black Friday savings, over-budget warnings, delivery-date checks and a daily spending allowance.
Build a holiday gift budget spreadsheet in 10 minutes: spend per person with SUMIFS, money left, percent used, Black Friday savings, over-budget warnings, delivery-date checks and a daily spending allowance.
Highlight an Entire Row Based on a Cell Value (Excel and Google Sheets)
Colour a whole row when a status is Done, a date is overdue or an amount is over a limit. Step-by-step conditional formatting with custom formulas, 12 copy-paste rules and fixes for when it highlights the wrong rows.
Colour a whole row when a status is Done, a date is overdue or an amount is over a limit. Step-by-step conditional formatting with custom formulas, 12 copy-paste rules and fixes for when it highlights the wrong rows.
2027 Calendar in Excel or Google Sheets: Formulas for Months, Holidays and Week Numbers
Build a 2027 calendar that updates itself: one formula per month, weekend and holiday highlighting, US and UK 2027 holiday dates with formulas, and ISO week numbers.
Build a 2027 calendar that updates itself: one formula per month, weekend and holiday highlighting, US and UK 2027 holiday dates with formulas, and ISO week numbers.
Discount Formulas in Excel and Google Sheets: Percent Off, Sale Price and Original Price
Copy-paste formulas for sale price, percent off, original price, stacked discounts, dollar-off vs percent-off deals, buy-one-get-one and price per unit.
Copy-paste formulas for sale price, percent off, original price, stacked discounts, dollar-off vs percent-off deals, buy-one-get-one and price per unit.
Working Days Left in 2026: NETWORKDAYS & WORKDAY
Count the working days left in 2026, build a holiday list, set deadlines with WORKDAY and handle custom weekends with NETWORKDAYS.INTL in Excel or Sheets.
Count the working days left in 2026, build a holiday list, set deadlines with WORKDAY and handle custom weekends with NETWORKDAYS.INTL in Excel or Sheets.
INDEX MATCH Explained: Lookups Left, Right and 2-Way
How INDEX and MATCH work together: exact lookups, looking left, two-way tables, multiple criteria and tiered rates, plus fixes for #N/A and #REF! errors.
How INDEX and MATCH work together: exact lookups, looking left, two-way tables, multiple criteria and tiered rates, plus fixes for #N/A and #REF! errors.
XLOOKUP vs VLOOKUP: Which to Use and How
Syntax, examples and the key differences between XLOOKUP and VLOOKUP in Excel and Google Sheets.
Syntax, examples and the key differences between XLOOKUP and VLOOKUP in Excel and Google Sheets.
How to Fix #N/A Errors in VLOOKUP and XLOOKUP
The six real causes of #N/A in lookups and the fix for each.
The six real causes of #N/A in lookups and the fix for each.
SUMIFS and COUNTIFS: 10 Practical Examples
Sum and count with multiple conditions: dates, text, wildcards and not-equal criteria.
Sum and count with multiple conditions: dates, text, wildcards and not-equal criteria.
How to Remove or Highlight Duplicates in Excel and Google Sheets
Menu methods and the UNIQUE formula to find, highlight and remove duplicates.
Menu methods and the UNIQUE formula to find, highlight and remove duplicates.
Percentage Change and Percentage of Total Formulas
Calculate percentage increase, decrease, percent of total and add a percentage to a price.
Calculate percentage increase, decrease, percent of total and add a percentage to a price.
How to Calculate Days, Workdays and Age Between Dates
DATEDIF, NETWORKDAYS and simple subtraction for days, months, years and age.
DATEDIF, NETWORKDAYS and simple subtraction for days, months, years and age.
IF, AND, OR and IFS: Writing Formulas With Conditions
Examples of IF with AND/OR, nested IF and the cleaner IFS function.
Examples of IF with AND/OR, nested IF and the cleaner IFS function.
Split and Combine Text: TEXTSPLIT, TEXTJOIN, LEFT, RIGHT, MID
How to split names, combine columns and extract parts of text in Excel and Google Sheets.
How to split names, combine columns and extract parts of text in Excel and Google Sheets.