Suoritettu

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

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).

Taidot: Excel

Näytä lisää: excel spreadsheet vba data entry form, paste data excel spreadsheet, copying data word document excel spreadsheet, how to compare two excel sheets for differences in values, how to compare two excel sheets for duplicates, compare two columns in excel for match, compare two columns in excel for differences, compare two columns in excel using vlookup, how to compare two excel files 2010, excel compare two lists and return differences, excel formula to compare two columns and return a value, exporting data excel spreadsheet quality center, excel spreadsheet data entry, google finance data excel spreadsheet, excel macro script insert data spreadsheet, create front end enter data excel spreadsheet, excel vba compare columns data report, excel spreadsheet analyze stock data, partime excel spreadsheet form filling data entry, excel spreadsheet automated data search create tables

Tietoa työnantajasta:
( 2 arvostelua ) Werribee Plaza, Australia

Projektin tunnus: #18935008

Myönnetty käyttäjälle:

TechnoGuruu

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 finish Lisää

$50 AUD 3 päivässä
(64 Arvostelua)
5.5

43 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

prameswara

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 Lisää

$30 AUD 0 päivässä
(336 arvostelua)
7.1
P0L

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 1 päivässä
(280 arvostelua)
7.2
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$25 AUD 1 päivässä
(106 arvostelua)
6.7
ksriniravi

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 Lisää

$20 AUD 1 päivässä
(171 arvostelua)
6.7
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$30 AUD 1 päivässä
(84 arvostelua)
5.5
catstevens2009

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 1 päivässä
(75 arvostelua)
5.5
lightingdavid

Hello. How are you. I have checked your project and i can do it. Contact me please. Thank you.. From Yang Li.

$50 AUD 1 päivässä
(51 arvostelua)
5.5
orugantn

Hi, I am good with excel and I can help you with the comparison project and should be done in a couple of hours. Can you please share the excel file. Please feel free to contact. Thank you! Regards, Nag Lisää

$25 AUD 1 päivässä
(28 arvostelua)
5.2
afenache

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 1 päivässä
(19 arvostelua)
5.1
RavinduJayzz

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. Lisää

$30 AUD 1 päivässä
(10 arvostelua)
4.6
ScareCrow01

I can help you with this. Thank you

$35 AUD 1 päivässä
(19 arvostelua)
4.2
dungchan44

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel Formula. I have finished a lot of projects like this. I can show you one of them if you want. I en Lisää

$20 AUD 0 päivässä
(14 arvostelua)
3.9
Ahmed818

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 1 päivässä
(29 arvostelua)
4.0
BHARATBEURA

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 Lisää

$30 AUD 2 päivässä
(14 arvostelua)
4.1
wafaajame

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 1 päivässä
(1 arvostelu)
1.8
rajamajid1981

I have read ur project description and I am confident that i can complete your project within specified time and budget. thanks

$28 AUD 1 päivässä
(1 arvostelu)
0.4
eriksongpealoza

hello, my name is eriksong peñaloza I am a mechatronic engineer, with experience in various areas of engineering. In the development of the projects linked to my career I use frequently excel I can develop the work f Lisää

$15 AUD 10 päivässä
(0 arvostelua)
0.0
yanghehua

I have finish this, can send you right now. I am a Microsoft certified Excel expert, contact me as your convenience.

$20 AUD 0 päivässä
(0 arvostelua)
0.0
lality15

this is very easy one day is enough perform this query.. allow me Thid project i will do this on priority.

$15 AUD 1 päivässä
(0 arvostelua)
0.0
cindylmaldonado

Hello. My name is Cindy Maldonado. I am new on freelancer and am looking to get a review. I am fluent in working in Microsoft Word and Excel. I pay close attention to detail, have a typing speed of 60wpm, and will work Lisää

$15 AUD 1 päivässä
(0 arvostelua)
0.0