I will fix excel and google sheets formula errors

Taiwan

I speak English

Google Sheets and Excel Automation Specialist

Hi, I'm Guan Wei. I build Google Sheets and Excel tools that save small businesses and Airbnb hosts hours every week. What I can do for you: • Dashboards that update automatically (KPIs, charts, mont...
About this Gig

Formula showing #N/A, #REF!, #VALUE! or just the wrong number? Send me the file and tell me what it should do. I'll fix it, usually within 24 hours.


I can help with:

- VLOOKUP, XLOOKUP or INDEX MATCH not finding matches

- SUMIFS or COUNTIFS giving the wrong total

- QUERY, FILTER, IMPORTRANGE and ARRAYFORMULA in Google Sheets

- Date formulas that break

- Formulas that got messed up after rows were copied or deleted

- Dropdowns, data validation and conditional formatting

- A new formula from scratch if you tell me what you want it to do


Every delivery comes with a short note in plain English on what was wrong, so you can handle it next time.


Works with Google Sheets and Excel (Microsoft 365, 2019, 2021). On an older Excel version? Tell me and I'll use formulas that work there.


Please send a copy of your file, not the original, and remove anything private first.


Not sure if it's a quick fix? Message me a screenshot. If it's a 5 minute job, I'll tell you.

Platform:

Excel

•

Google Sheets

Development technology:

VBA

•

Excel

•

VLOOKUP

Expertise:

Formatting

•

Fixing

•

Formulas

•

Functions

•

Data validation

My Portfolio