I will fix excel formulas, add dropdowns and data validation

Kazakhstan

I speak English

Data Cleanup and Spreadsheet Automation

Most spreadsheets I get sent look the same: one customer in three times, phone numbers in four formats, a totals column somebody broke in 2023. I fix that. Cleaning and deduplicating lists. Standardi...
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

  1. Send the file and describe what's wrong or what you want it to do.
  2. 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