Find Jobs
Hire Freelancers

Create Excel spreadsheet to compare two columns of data (new and old) - no macros preferred

$10-30 AUD

Completed
Posted about 5 years ago

$10-30 AUD

Paid on delivery
I want to build an excel spreadsheet to use as a tool for that compares a list of names and their associated cost to the new list of names and the new associated costs. The data is as follows: Column1: Name(old list) Column2: Cost(old list) Column 3: Name(new list) Column 4: Cost(new list). I want the spreadsheet to tell me if column 3 has any new names on the list from column 1, or if there are any names that are on column 1 that are not on column 2. I also want the spreadsheet to compare column 2 and column 4 to see if there’s been any increase or decrease in cost for each of the names. (The data is not sorted and column 1 and 3 don’t line up row by row).
Project ID: 18935008

About the project

40 proposals
Remote project
Active 5 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, As per requirements I will develop Excel sheet for you which will compare all 4 columns as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan
$50 AUD in 3 days
5.0 (82 reviews)
6.0
6.0
40 freelancers are bidding on average $24 AUD for this job
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$25 AUD in 1 day
4.9 (113 reviews)
7.0
7.0
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do help build tools in excel for ompare column 2 and column 4 to see if there’s been any increase or decrease in cost for each of the names please ping me now and im able to start working right now Thank you Galih
$30 AUD in 0 day
4.9 (361 reviews)
7.2
7.2
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 AUD in 1 day
4.9 (325 reviews)
7.3
7.3
User Avatar
Greetings! There is a case to consider separating New or Lost Client? column into 2 separate columns. There is a possibility that a given row might have a new client in Col C and a lost Client from corresponding Col A. I can provide a solution WITHOUT the use of macros. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$20 AUD in 1 day
5.0 (188 reviews)
6.8
6.8
User Avatar
Hi there! Have done this type of work before and am an excel expert. Please feel free to message me with additional information or with questions if any. I am available now to work on this job.
$25 AUD in 1 day
5.0 (80 reviews)
5.5
5.5
User Avatar
Hello. How are you. I have checked your project and i can do it. Contact me please. Thank you.. From Yang Li.
$50 AUD in 1 day
4.8 (90 reviews)
5.8
5.8
User Avatar
Hey there ! This looks an easy task for my Excel Knowledge ! I have done alot of similar work before and i can do this using Formulas and by not using Macros. Hope to hear from you and work with you on this project. Thanks :)
$30 AUD in 1 day
5.0 (26 reviews)
5.6
5.6
User Avatar
Hi, I can build the excel sheet taht will compare your data and highlight all the things that you mentioned. Best regards, Florin Enache
$30 AUD in 1 day
5.0 (22 reviews)
5.3
5.3
User Avatar
HI, MYSELF BHARAT. I AM AN EXCEL EXPERT. I AM EFFICIENT IN MICROSOFT OFFICE TOOLS AND ALSO EXPERIENCE IN SORTING DATA, CATEGORIZING ITEMS, REMOVING DUPLICATES, WORKING WITH FUNCTIONS OR FORMULAS, COMPARING SHEETS FOR UNIQUE DATA ETC. I CAN WORK ON ANY KIND OF EXCEL WORK. I HAVE THE ABILITY TO FOCUS ON THE TASKS GIVEN AND ALSO POSSESS EXCELLENT ENGLISH COMMUNICATION SKILLS. I LOOK FORWARD TO WORKING WITH YOU SOON.
$30 AUD in 2 days
4.7 (23 reviews)
4.6
4.6
User Avatar
Hello, i can write small vba script to do this comparison between columns i can finish in few hours waiting your answer Thank you
$20 AUD in 1 day
4.9 (43 reviews)
4.3
4.3
User Avatar
I can help you with this. Thank you
$35 AUD in 1 day
5.0 (20 reviews)
4.3
4.3
User Avatar
I have read ur project description and I am confident that i can complete your project within specified time and budget. thanks
$28 AUD in 1 day
5.0 (1 review)
3.6
3.6
User Avatar
Hi, I have a strong experience in Excel so I can do the excel sheet and make comparing using a function in excel Really I want to work with you so Message me Regards wafas
$25 AUD in 1 day
5.0 (1 review)
1.8
1.8
User Avatar
Sir, I am good in MSoffice application And i can do above task as soon as possible we can discuss more details through dm
$15 AUD in 1 day
0.0 (0 reviews)
2.5
2.5
User Avatar
I am an expert in Data Extraction and Data Management especially in Microsoft Excel formulas and other useful tools to ease your load in data management since I am a BS Statistics graduate and I am exposed to researches which corresponds to this kind of projects.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can make a spreadsheet to make a comparison of the list and names and each cost for column 1,2 and 3.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I've been working with excel for more than 8 years. I can done this task in a couple of hours. this task only require some formula to compare and some sort moves
$14 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Solo hay que vaciar los datos de las respectivas listas y utilizar varias formulas sencillas de excel para obtener los campos con la informacion que se desea, identificando bien cada resultado, segun lo solicitado.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Purificacion B. Canceran. I have 15 years of administrative and customer service experience. My CORE SKILLS: - Data Processing - Data Scrapping - Data Entry - Data Transcription - Researcher - Email Management - Calendar Management - MS Excel - MS Word - MS Powerpoint - Planning MY CORE COMPETENCIES: - Ability to cope up with failure and learn from mistakes - Result and goal-Oriented - Dedicated and Committed to working - Attention to detail - Responsible - Flexible - Written and Verbal Communication - Resourceful - Organization - Time Management - Strategic Planning I have the ability to work on tight deadlines and I can effectively manage my time and prioritizing my task. Developing a good rapport, regular and effective communication is important to me. It ensures the project is completed to the specific guidelines required.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very interested, I have worked with Excel before this kind of things, it shouldn't be so complicated what you ask. It is important to know that excel uses for compatibility issues, if you use 2013-2016 would be ideal.
$20 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Werribee Plaza, Australia
5.0
2
Payment method verified
Member since Aug 28, 2007

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.