Find Jobs
Hire Freelancers

Do some Excel merge work

$10-30 AUD

Completed
Posted almost 8 years ago

$10-30 AUD

Paid on delivery
We would like the first document (HPP) merged and reorganised like in the example document. Some customers have been listed many times, and we want them merged into one entry per customer. Most of the details will remain the same, and the invoice total will need to be summed. The only tricky ones are: HPP sold: We want the most recent purchase of silver/gold/platinum OR none/blank if there are none. Eg. None None Silver None = silver. Or Gold None Silver None = silver. Or None None None Gold =gold And the other one is the invoice date: We want this date to be the invoice date from the row with the gold, silver, or platinum. So: None 1/1/16 None 2/1/16 Silver 3/1/16 None 4/1/16 =3/1/16 Please let me know if you have any questions! Please see the example for more information.
Project ID: 10394782

About the project

26 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi sir, I will merge the excel sheet rows as per specification. Ready to start now and complete right away with 100% accuracy. thanks
$15 AUD in 1 day
5.0 (459 reviews)
6.8
6.8
26 freelancers are bidding on average $26 AUD for this job
User Avatar
HI, With reference to your proposal, I UNDERSTOOD YOUR REQUIREMENTS. Besides my excellent oral and written communication skills, I have cognate experience in typing (80 words/minute), in data mining (web scraping), and in data entry (using Microsoft Word and Microsoft Excel). I would be very pleased to assist you to carry out the Excel merge work. I look forward to hearing from you soon. Warmest regards Amiable Writer
$20 AUD in 1 day
5.0 (227 reviews)
7.5
7.5
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex webscrapping, Amazon, aliexpress, VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$64 AUD in 2 days
4.9 (87 reviews)
6.2
6.2
User Avatar
Hello, I would be glad to help you in this project. I manage excel and vba very well so I'm capable to help you with this. If you want contact me to further details. I hope hear from you soon. Regards, Luis ROMERO
$30 AUD in 1 day
5.0 (177 reviews)
6.1
6.1
User Avatar
Hello, I am proficient with Excel and VBA and I would love to write a script that would do what you require. Please contact me for more information.
$30 AUD in 1 day
4.9 (144 reviews)
5.9
5.9
User Avatar
Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to fulfill your requirements. Pm me for more information and sample as well. Thank you for your opportunity to bid. RoyalCalif
$30 AUD in 2 days
4.9 (85 reviews)
6.0
6.0
User Avatar
Can provide few sample let you review first. I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm looking forward to serve you, on your available task.
$30 AUD in 1 day
4.7 (43 reviews)
4.6
4.6
User Avatar
Dear sir It needs at least 3 days for finishing 27.000 data to be revised and correct. I have so much experience and if you choose me, i will be glad to finish this project Best regards
$30 AUD in 3 days
5.0 (1 review)
2.6
2.6
User Avatar
Dear Sir, I have expertise knowledge on Microsoft Word, Microsoft excel, data entry and web research. I have several work experience like this. I am able to start from now and complete the task with quick turnaround. You can take a test before give this job to me. I am looking forward to hearing from you.
$20 AUD in 3 days
5.0 (5 reviews)
2.0
2.0
User Avatar
Hello My name is Rainy and I am from India. I am an excel expert and have gone through your job post. i had a question: in your post on 2nd no. example which was Gold None Silver None = silver. I think it should be Gold and Silver. I can handle this project. Looking froward to hear from you. Thanks Rainy
$25 AUD in 1 day
5.0 (4 reviews)
1.6
1.6
User Avatar
I am an experienced data entry, processing and mining specialist with excellent knowledge in analyzing, transforming and presenting large volumes of data. I possess advanced knowledge of programming/scripting languages, excel and other supporting tools to accomplish my tasks in a timely manner. Additionally, I pay exceptional attention to the details and automate the process (wherever possible) to ensure 100% accuracy. For this assignment, I can write a script/program to automate this process
$30 AUD in 1 day
4.3 (2 reviews)
2.0
2.0
User Avatar
Hello Sir, I read ur job details carefully and also check the attachment files. I am fully clear about your task and offering my self for your job with my best efforts . Waiting for hearing from u soon to start work. Thanks Rozana
$30 AUD in 3 days
5.0 (2 reviews)
1.6
1.6
User Avatar
Excellent typing speed with good command over Microsoft office. Good work ethics with zero errors in typing and timely completion of work.
$15 AUD in 1 day
4.9 (4 reviews)
1.1
1.1
User Avatar
Hello - I would be happy to complete this work and send the Excel file back to you. Jason
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert with excel and can definitely get it done with 100% accuracy. See my feedbacks as a I have some excel works in the past. Let me know if you are interested.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Saya terbiasa dengan pekerjaan seperti ini. Saya tidak akan berhenti dari komputer saya sebelum menyelesaikannya.
$25 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do this work for $14 in one day .I will do my best for you and won't give you any chance to regret.
$19 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I ensure that material is clear and consistent, complete and credible, I work on a range of publications including websites and other electronic resources. Areas of Expertise: =/ Social Networking =/ Email Handling =/ Web Search =/ Data Entry\Processing =/ Excel and Word Data Entry and Solutions =/ Research =/ PDF to Excel & Word. Experience as follows: -Virtual Assistant -Editor -Credential Analyst -Customer Service Representative -Data Entry Executive -Data Specialist =/Quality over Quantity
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Can easily make datasheet, Hands on experience in my office and also developed in my college. Can complete your work in given deadline.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager, I have related sort of expertise and can deliver the best. I will ensure the highest standard to satisfy you. I will ensure the best and will share the ideas with you. Let us discuss about the project.
$15 AUD in 0 day
5.0 (1 review)
0.0
0.0
User Avatar
I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, I am the Right person for you and available 24-7. a trusted Freelancer.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Pennant Hills, Australia
5.0
28
Payment method verified
Member since Jun 25, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.