Closed

Excel Matching

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

Skills: Data Entry, Excel

See more: excel formula spreadsheet, excel spreadsheet formula, excel sheet formula, excel help formula, master excel, excel formula, spreadsheet manipulation, excel digit, create sheets data sheet, fix excel, excel match formula, excel time sheet, matching items, return time excel, fix formula, excel date sensitive formula, formula sheet, spreadsheet excel word, replacement parts, word matching project, data matching project, matching excel, time sheets excel, word sheets data, questions formula

About the Employer:
( 0 reviews ) Rawalpindi, Pakistan

Project ID: #4011644

8 freelancers are bidding on average $13/hour for this job

javed1705

dear sir please check pm

$15 USD / hour
(39 Reviews)
5.4
kiranbmohan007

Hai, I can do this work for you in more precise please see PMB

$10 USD / hour
(0 Reviews)
0.0
sac0

pls see my PM

$8 USD / hour
(0 Reviews)
0.0
HandOverSolution

Dear Shakeel, Data cleansing exercises are usually pretty straight forward and my associates & I have had a lot of experience in extracting data from websites, moving them into spreadsheets, cleansing the data, and More

$30 USD / hour
(0 Reviews)
0.0
excelguy7

I am a professional data analyst, and I work with extremely large data sets daily. I can create formulas (VLookups), and clean the data so that all of the categories (codes) conform to the proper text exactly as you w More

$12 USD / hour
(0 Reviews)
0.0
isaacpato

This is my first bid, but I am very confident that I can create a spreadsheet that fits your needs within a few days. If you want, I would be happy to provide you with a sample of my work. As an initial milestone, I wo More

$8 USD / hour
(0 Reviews)
0.0
kimball11

I have been developing with Excel for more than 15 years creating many kinds of applications for my organization. Excel has several search functions that will enable me to give you the best matching accuracy. I am More

$12 USD / hour
(0 Reviews)
0.0
sharpico

I have made 100s of such data-matching programs in unix and "awk" (A spicy programming language based on pattern-matching) and I can assure you of un-matched quality and accuracy in this matter. (Pl See attached messag More

$8 USD / hour
(0 Reviews)
0.0