176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Match Data in Two Excel Tables by Non-Identical Firm Name
Sign in to Add to Watch List

Admin Support > Data Entry

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Feb 14, 2013

Job awarded.

Feb 14, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, Feb 14, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have 700 firms I need matched up as described below (with a fast turn around)

1) Take a company name from Firm IDs file and search Patent Code List file (Control+F for Find in Excel) for a matching name. Note: Names are not identical so ignore the "Inc" or "Corp" or "Group" or "Holding" or "LTD" (etc) at end of company name in either table. However if the rest of the name does not match then it is not a match.

2) If there is no match put a "M" in the Type column in Firm IDs

3) If there is a match enter the 4 character code in the Patent Code column in Firm IDs and the adjacent type in the Type column. Note: The only types that matter are "C" and "N". "R" and "I" types should be ignored and if there is no "C" or "N" based match follow #2 for no match.

4) Repeat.

------------------------------------------------------------------------
Matching Example

...

Sign in or Register to see more

Desired Skills
Data Entry, Microsoft Excel
Job ID: 37895592
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Ukraine  |  
I am native Russian/Ukrainian speaker with good English skills, able to make quality English-Russian, English-Ukrainian translations. Accurate,...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37896510  |  Submitted: Feb 14, 2013 17:06 ET 
Proposal SEALED

 Romania  |  
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37896397  |  Submitted: Feb 14, 2013 17:02 ET 
Proposal SEALED

 Philippines  |  
Native Tagalog and proficient in Finnish Language I guarantee high quality work in Translating Services. My specialization include business...
1
  |  
 5.0   |  Private   |  5 Jobs
Bid ID: 37896272  |  Submitted: Feb 14, 2013 16:57 ET 
Proposal SEALED

 Kenya  |  
Our strength through these years, are our clients whom we have created loyalty and trust which is our fundamental business principal that keeps...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37896130  |  Submitted: Feb 14, 2013 16:51 ET 
Proposal SEALED

Harry B.      
Harry B.'s identity has been verified.  Learn More
 United States  |  
Winner
Specializing in data extraction and conversion using automation tools. Excel expert. Over 30 years experience including software engineering,...
6
  |  
 5.0   |  $1,257 Earnings   |  23 Jobs
Bid ID: 37896052  |  Submitted: Feb 14, 2013 16:48 ET 
Delivery
Within 1 day
$70.00

 Romania  |  
Winner
I am hardworking, I can work accurate and fast, I am ambitious, respectful, good with deadlines. I have successfully completed a lot of projects...
3
  |  
 5.0   |  $105 Earnings   |  2 Jobs
Bid ID: 37896037  |  Submitted: Feb 14, 2013 16:47 ET 
Delivery
Within 1 day
$20.00

 Ukraine  |  
INVITED
I'm experienced VBA developer focused on creating of advanced business tools for Microsoft Excel. Also I work with other Microsoft Office...
4
  |  
 4.8   |  Private   |  1 Jobs
Bid ID: 37895932  |  Submitted: Feb 14, 2013 16:44 ET 
Proposal SEALED

 Pakistan  |  
If you are looking fairly-priced administrative work, done in a timely manner with professionalism and a smile, I'm your guyl! I have a varied...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37895921  |  Submitted: Feb 14, 2013 16:44 ET 
Proposal SEALED

 Pakistan  |  
I am Expert in Creating Excel Files fom PDF Documents and also from Websites according to the Requirements of the our Valued Clients
5
  |  
 4.9   |  $537 Earnings   |  15 Jobs
Bid ID: 37895879  |  Submitted: Feb 14, 2013 16:42 ET 
Proposal SEALED

 United States  |  
INVITED
I am a young and energized Accountant with 5 years of related work experience at a top ranked University institution in Miami, FL. Knowledge...
1
  |  
 0.0   |  $356 Earnings   |  3 Jobs
Bid ID: 37895717  |  Submitted: Feb 14, 2013 16:36 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »