Excel Data Cleanup ASAP
Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a Microsoft Excel workbook that has grown messy and it now needs an immediate refresh. The sheet contains duplicate rows, inconsistent cell formats, and several columns that should be locked down with proper data-validation rules.
Your main objectives are to:
• Identify and eliminate every duplicate record without affecting unique data.
• Standardise cell formatting—numbers, dates, text cases—so everything is consistent throughout the file.
• Apply clear, reliable validation rules (drop-downs, restricted ranges, error prompts) to stop bad entries going forward.
Please return a fully cleaned version of the file along with a brief note outlining the changes you made, so I can trace the logic if needed. Speed is critical—I’d like this wrapped up as soon as you can turn it around today.
Your main objectives are to:
• Identify and eliminate every duplicate record without affecting unique data.
• Standardise cell formatting—numbers, dates, text cases—so everything is consistent throughout the file.
• Apply clear, reliable validation rules (drop-downs, restricted ranges, error prompts) to stop bad entries going forward.
Please return a fully cleaned version of the file along with a brief note outlining the changes you made, so I can trace the logic if needed. Speed is critical—I’d like this wrapped up as soon as you can turn it around today.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.