Practical help. One cell at a time.

Spreadsheet
problems.
Clearly solved.

Make the formula work. Keep your data intact. Get a clear answer you can actually use.

Find your next answer Explore free tools →

✓ Excel & Google Sheets No account needed

E2 ▾ƒx=SUMIFS(C2:C5,A2:A5,"North",B2:B5,"Closed")

Fictional sales data with a manually checked total
	A	B	C
1	Region	Status	Revenue
2	North	Closed	240
3	South	Closed	180
4	North	Closed	360
5	North	Open	90

North + Closed 6002 matching rows

✓Know why it works.Not just what to paste.

A good place to start

A little less trial and error.

Formulas

Find the right function. Understand every argument.

Data Cleaning

Keep the data you need. Fix the data you do not.

Troubleshooting

Trace an error back to its cause.

Templates

Small, transparent starting points you can inspect.

Comparisons

Know what changes when you switch apps.

Practical guides

From stuck to sorted.

View all guides ↗

Comparisons01

Excel vs Google Sheets: Formula Compatibility Differences That Matter

Compare FILTER signatures, array formulas, lookup version support, and date inputs using a small migration checklist and expected outputs.

5 min read

Formulas02

Google Sheets FILTER Function: Practical Examples and Common Errors

Copy Google Sheets FILTER examples for one condition, AND, OR, and no matches, using a five-row dataset with expected outputs.

4 min read

Troubleshooting03

How to Fix XLOOKUP Not Working in Excel

Diagnose unsupported Excel versions, missing matches, mismatched ranges, and duplicate keys with a small XLOOKUP repair dataset.

4 min read

Data Cleaning04

How to Import CSV Files Without Losing Leading Zeros or Changing Dates

Preserve CSV identifiers and date text during import, then validate raw values before converting any dates in Excel or Google Sheets.

5 min read

Data Cleaning05

How to Remove Duplicate Rows in Excel and Google Sheets Safely

Choose duplicate keys, preview keep-first results, and avoid deleting meaningful revisions in Excel, Google Sheets, and raw CSV files.

5 min read

Formulas06

IFERROR vs IFNA in Excel and Google Sheets: Fix Errors Without Hiding Problems

Learn when to use IFERROR or IFNA in Excel and Google Sheets, with two reproducible example tables, a diagnostic decision tree and safer error-handling formulas.

11 min read

Less busywork. More doing.

Small tools. Real time saved.

Free to use. Built for your browser.

Sound familiar?

Start with your problem.

“My lookup keeps returning an error.”“My IDs lost their leading zeros.”“Which duplicate rows should I keep?”“I need totals for a specific month.”

Built on clear working

Useful examples.
Honest about the limits.

We make the inputs, expected outputs, and sources visible—so you can follow the reasoning, not take our word for it.

How we check our guides ↗

Official sources first

Microsoft and Google documentation, linked where it matters.

Examples you can inspect

Original, fictional datasets with explicit expected results.

Clear testing boundaries

A logical check is never presented as a live app test.

An accountable publication

Maintained by emfls, with a real correction route.

Spreadsheetproblems.Clearly solved.

A little less trial and error.

Formulas

Data Cleaning

Troubleshooting

Templates

Comparisons

From stuck to sorted.

Excel vs Google Sheets: Formula Compatibility Differences That Matter

Google Sheets FILTER Function: Practical Examples and Common Errors

How to Fix XLOOKUP Not Working in Excel

How to Import CSV Files Without Losing Leading Zeros or Changing Dates

How to Remove Duplicate Rows in Excel and Google Sheets Safely

IFERROR vs IFNA in Excel and Google Sheets: Fix Errors Without Hiding Problems

Small tools. Real time saved.

CSV Duplicate Checker

Formula Finder

Start with your problem.

Useful examples.Honest about the limits.

Spreadsheet
problems.
Clearly solved.

Useful examples.
Honest about the limits.