Færdiggjort

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

Evner: Excel

Se mere: 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

Om arbejdsgiveren:
( 2 bedømmelser ) Werribee Plaza, Australia

Projekt ID: #18935008

Tildelt til:

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 Flere

$50 AUD in 3 dage
(64 bedømmelser)
5.5

43 freelancere byder i gennemsnit $24 på dette job

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 Flere

$30 AUD in 0 dage
(336 bedømmelser)
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 på 1 dag
(280 bedømmelser)
7.2
zebracaro

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

$25 AUD på 1 dag
(106 bedømmelser)
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 Flere

$20 AUD på 1 dag
(171 bedømmelser)
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 på 1 dag
(84 bedømmelser)
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 på 1 dag
(75 bedømmelser)
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 på 1 dag
(51 bedømmelser)
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 Flere

$25 AUD på 1 dag
(28 bedømmelser)
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 på 1 dag
(19 bedømmelser)
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. Flere

$30 AUD på 1 dag
(10 bedømmelser)
4.6
ScareCrow01

I can help you with this. Thank you

$35 AUD på 1 dag
(19 bedømmelser)
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 Flere

$20 AUD in 0 dage
(14 bedømmelser)
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 på 1 dag
(29 bedømmelser)
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 Flere

$30 AUD in 2 dage
(14 bedømmelser)
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 på 1 dag
(1 bedømmelse)
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 på 1 dag
(1 bedømmelse)
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 Flere

$15 AUD in 10 dage
(0 bedømmelser)
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 in 0 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 Flere

$15 AUD på 1 dag
(0 bedømmelser)
0.0