Excel Matching

  • Status Closed
  • Budget $8 - $15 USD / hour
  • Total Bids 8

Project Description

We have 4 spreadsheets (thousands of lines in each) containing automotive replacement parts that need to be matched up with our master spreadsheet of autos. I need someone that can:

1. Create formula's to match anything that is an exact match.

2. Make analytical decisions to correct data that could be preventing an exact match (extra spaces, miss-spelling, reversed order, etc..)

3. Return the results in 5 worksheets: Exact Matches, Matches with Light Manipulation (trim extra spaces, fix word order, change date from 2 digit to 4 digit, etc..), Matches with Heavy Manipulation (miss-spellings, multiple items on one line, etc..), Items in Master Sheet that were not a match to our 4 part list sheets, and Items in our 4 part lists sheets that were not a match to our master sheet.

This project is time sensitive and HIGHLY ACCURACY SENSITIVE, and needs to be returned in the quickest timeframe possible. We are available 8:30am to 4:30pm EST to answer any questions or help make any decisions in regards to the data.

Thank You

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online