login
Forgot?
Login with Facebook

Don't have an account? Register one now!

Remove duplicates add the numbers (Excel file)

Bids 
5
Avg Bid
$73 USD
CLOSED

  • Project ID:

    752673

  • Project Type:

    Fixed

  • Budget:

    $30-$250 USD

Project Description:

I have an excel file with 38,000 lines.

This file is broken up in two columns. Words and Numbers.

For the words columns I need all the duplicates removed.
For the numbers columns I need the numbers added up from the removed columns.

Here is an example of what I have:

Automotive 2
Automotive 4
automotive 1

What I want it to look like is this:

Automotive 7


So it will remove those other duplicates and then add the numbers to the remaining column.


I also want this file to not care about Caps....So
Automotive and
automotive should be considered the same.


Thanks!


Michael R Roberts

Skills required:

C++ Programming, Data Entry, Data Mining, Excel
See more: excel 2010, excel add, automotive data entry, numbers entry, data entry numbers, numbers excel, remove words file file, caps, produce look file excel list, online convert mac numbers file excel, csv file excel add, script add remove file lines, converting dat file excel, attched word file excel, convert dat database file excel, convert bak file excel, attached word file excel, convert dat file excel

Project posted by:

mroberts23 United States
(115 Reviews)
Last seen:
Post a Project like this Report Project

Public Clarification Board

4 messages

If you are the project creator or one of the bidders, please Log In for more options.


Awarded Bids

Freelancers   Bid (USD) Time of Bid Freelancer Reputation
WebSolution4 United States
WebSolution4
United States From United States     Offline
  Foundation Freelancer.co.uk Member
  Foundation EUFreelance.com Member
 Accepted
$33 in 1 day 
0
over 1 year ago
5.0
2.8
2 Reviews
40% Completion Rate
Hi, Please view PM. Thank you

All Bids ()

Freelancers Msg Bid (USD) Time of Bid Reputation
FINGERRPRINT India
Picture5-final.png
FINGERRPRINT
India From India     Gold Member     Offline
  Freelancer Orientation (90%, 100th percentile)
  Employer Orientation (85%, 100th percentile)
  General Freelancer Orientation (95%, 100th percentile)
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$100 in 1 day 
$100 Milestone Requested
over 1 year ago
4.9
6.6
64 Reviews
88% Completion Rate
Ready to work perfectly as per your requirement.

wsh2 United States
wsh2
United States From United States     Gold Member     Offline
$32 in 1 day 
$32 Milestone Requested
over 1 year ago
4.8
4.8
11 Reviews
86% Completion Rate
Greetings Oregon from Pennsylvania.. {smile} 25+ year MsExcel expert.. I can have you all grouped and totalled up very little time. Please see PMB. Respectfully, Bill.

sehgals Pakistan
main (4).jpg
sehgals
Pakistan From Pakistan     Gold Member     Online
  Freelancer Orientation (75%, 94th percentile)
  General Freelancer Orientation (85%, 95th percentile)
$100 in 0 days 
$100 Milestone Requested
over 1 year ago
4.9
4.1
22 Reviews
92% Completion Rate
ready to to start right now...

mcimino Australia
mcimino
Australia From Australia     Offline
  Foundation LimeExchange Member
$100 in 1 day 
$100 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
Hi, This is a fairly simple task, I can do this for you immediately. Thanks

Freelancer.com (formerly GetAFreelancer) is the world's largest outsourcing and crowdsourcing marketplace for small business. We have hundreds of thousands of satisfied customers from all over the world. We connect over employers and freelancers globally from over 234 countries & regions. Through our website, employers can hire freelancers to do work in areas such as software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services. The average job is under US$200, making outsourcing for the first time extremely cost effective for small businesses.

Would you like to find freelance jobs and make money online? Just sign up to get started! We have created a safe environment for both freelancers and employers via our secure milestone payment system. We have thousands of freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.

© Copyright 2011 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)