GetACoder.com

 
 

Home | My Account | Post Job | Browse Jobs | RSS Feeds | Careers New!

 

Matching List Items Excel

 
 
     
Job Summary:
 
Job Type: Project
Budget: $ 20-100
Required Skills: Administrative Support, Data Entry, Fact Checking, Other (Administrative Support)
Attached Files: venue-lists-sample.xls
 
Status: Work Performed (selected user proofpoint)
 
Buyer Summary:
 
Username:
chrispynic99  
Feedback Score: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 11 reviews
Award Reliability: 21 posted 11 paid
 
Location: Houston, Texas, United States
Member Since: June 23, 2008
 
Invited Users: There are no invited users


Description
I need to match values from four lists against one master list key. The values do not match exactly, so thereby have to be matched manually. For example, in the master list the value is "Memorial Stadium - IL" while in one of the other lists the value is "Memorial Stad. (IL)".

Here are the facts, and I have also attached an example:

*About 60% of the values have already been matched using VLOOKUP (exact) in excel. VLOOKUP (approximate) CANNOT be used because the lists are different length and some of the values that exist in the lists to not exist in the master.

*IMPORTANT - I expect that only about 75% of the values can be matched manually, so you will leave the cells blank next to values that cannot be matched against an event in the master key.

Master List (7,955 values)

*List One (1,545 values, 706 unmatched)
*List Two (1,140 values, 518 unmatched)
*List Three (1,122 values, 509 unmatched)
*List Four (200 values, 69 unmatched)

You will need to use your best judgment on matching these values, so excellent English skills are preferred.

Budget is $30-40

Here are some examples from the test file:

1) In List One Match "1018 Club" with "1018 Augusta Club" from the Master List, replace "#N/A" with "3" (C2).

2) In List no suitable match for "3rd & Lindsley", so delete "#N/A" (C4) and leave blank.

3) In List One Match "Admiral Theatre - WA" with "Admiral Theatre" from the Master List, replace "#N/A" with "122"(C14)




Additional information: Submitted on 10/26/2008 at 7:31 EDT

For reference, I completed one other list (not included in this project) with over 500 unmatched values in about 3 hours. I think that this while project can be done in 10-12 working hours.




Reminder
You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.



Place Bid | Post Similar Job | Send Request | Contact chrispynic99

Order by:

 

 chrispynic99 has chosen to keep all bids for this request hidden

 

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.
 

 
 


 
Get the Free Step-by-Step Guide on How to Use GetACoder
The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:
  • How to outsource safely
  • How to pick the best freelancers
  • How to manage time and money

Coders will learn:

  • How to get the best jobs
  • How to secure their payments
  • How to build a long-lasting relationship with buyers

    ...and MUCH MORE
Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide.  So don't loose the outstanding opportunity to download GetACoder FREE E-book.
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
What is GetACoder?

GetACoder.comGetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes


-I Love this website. It is a major help for Students. - macsuresh
-It's good to be an associate member of GetAcoder. - pretty09
-I love this website and everything in it. - azizul24
Report Violation    Privacy Policy     Affiliate Program    Terms of Use    Contact Us    Help      GetACoder.com on Facebook      Follow GetACoder on Twitter      GetACoder.com Latest Requests RSS Feed
© 2004-2012 GetACoder. All rights reserved.