I will fix excel formulas, add dropdowns and data validation
Data Cleanup and Spreadsheet Automation
About this Gig
A formula that returns #REF! since someone deleted a column. A VLOOKUP that only works on half the rows. A sheet where three people type the same thing four different ways. Small problems, but they eat hours every week. I fix them fast.
What I do
- Fix broken formulas and write new ones: lookups, SUMIFS, IF logic, date math, text splitting and joining
- Add dropdown lists so entries are always consistent
- Set validation rules so bad numbers, dates and emails get rejected at entry
- Conditional formatting that highlights overdue, missing or out-of-range values
- Small automations in Google Sheets: a button that clears a form, moves done rows, or emails a summary
How it works
- Send the file and describe what's wrong or what you want it to do.
- I fix it and send it back with a short note explaining each change, so you're not stuck if you need to adjust it later.
Works in Excel and Google Sheets. Not sure if your problem fits a package? Message me first and I'll tell you
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Google Apps Script
•
Excel
•
VLOOKUP
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Data validation
My Portfolio
FAQ
Can you fix it inside my existing file without breaking anything else?
Yes, I work on a copy, change only what we agreed, and list every cell I touched in the delivery note
Do I have to share the whole file?
No, a copy with the affected sheets is enough, and you can replace sensitive data with dummy values as long as the structure stays the same
What if I need more formulas than the package includes?
Add the "additional formula" extra at checkout, or message me with the list and I'll send a custom offer

