Terminé

Compare two spreadsheets (.xlsx/csv) and tell which are missing

Hello

I need a simple script/program/solution for windows which compare two spreadsheets via column A in both files.

If column A in spreadsheet 1 contains values which are not in column A in spreadsheet 2, then it outputs these values (with all rows for that column).

A spreadsheet can contain 3-5000 values.

Simple project/Script - If in doubt ask first before bidding.

Compétences : Programmation C++, Traitement de Données, Excel, Excel Macros, Programmation

en voir plus : csv files compare, script compare spreadsheets, compare sql table csv file count, how to compare two excel sheets for duplicates, how to compare two excel sheets for differences in values, compare two excel sheets and highlight differences, compare and merge workbooks, compare two excel sheets and highlight differences macro, compare two excel files online, how to compare two excel sheets using vlookup, how to compare two excel files 2010, python compare spreadsheets, xlsx csv ruby, xlsx csv freebsd, perl xlsx csv, csv files compare delphi, convert xlsx csv php, visual basic compare spreadsheets, highstock compare multiple series csv, compare excel columns csv columns

Concernant l'employeur :
( 58 commentaires ) Noerresundby, Denmark

Nº du projet : #18463689

Décerné à:

MohsanEijaz

I shall make a simple script/program/solution for windows which compare two spreadsheets via column A in both files. MOhsan

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(72 Commentaires)
6.2

38 freelance font une offre moyenne de $28 pour ce travail

SBITServices

Hello , I will write Excel VBA Macro for your requirement, that compare First file A column data with Second file A column data and picks all unmatched records from File 1 into separate sheet. I have 5 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(420 Commentaires)
7.4
leelakalidas32

i am Ajay from India without wasting our both time i want to work for your sample file for selection for this [login to view URL] allow me to start sampling .contact me anytime i am always here. Relevant Skills and Exper Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(213 Commentaires)
6.9
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(295 Commentaires)
6.6
sheikhakash786

Hi there, I'm a Data entry, Scraping, Excel and Digital Marketing Expert. I have read your project details. I'll compare two spreadsheets via column A in both files within few hours. I use premium tools to deli Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(80 Commentaires)
6.2
kcbStar

Hello, I am interested in this project and so wanted to discuss more it in details. I have a lot of experience in C++ programming. I will provide you quality work according to your instrument. I am ready to discuss wit Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(76 Commentaires)
5.9
macroPOL

Hello, I am Excel and VBA expert. I can do it today (VBA macro). The description is clear. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(92 Commentaires)
6.0
imanolie

Hi there, I cannot ask without bidding. So, my question is: do you want the difference between spreadsheets to be displayed in another spreadsheet? I can give you a small java app. you'll have to have java instal Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)
5.0
Capitan0Trueno

Aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(30 Commentaires)
4.6
xinglong717

Hi. I'm Enkhbayar B in Japan. I have read your description in detail and have interests in your project. I have many experiences that have ever done what is similar to your project. As a solution, I have a good Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(19 Commentaires)
4.7
afenache

Hi, I can build a VBA script to compare your spreadsheets data and highlight the all records that are missing. Best regards, Florin Enache

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
4.2
MasterKym

Hello, I am a data analyst and a programmer. If I understand correctly, you want to display unique values in one file and not the other. This could be achieve relatively easily using an inner join. Reach out to me f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)
4.3
imRaziel

i can make simple console app in c# for this. or make gui too if needed. will need sample data files and expected output for them .

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
4.4
prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)
4.5
wikkipk

Hi, It's very simple for me. I'll deliver within few hours after the bid acceptance. Do you just need the results or the script as well ? Regards, Waqas Ahmed

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
4.0
SunniaImran

Hi Here is the right person you are looking for. I am willing and ready to take up your project right away. I am sure that I can do it within your required time and format. The client satisfaction is always my prim Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
3.8
Selameab

Hello, I am interested in building your spreadsheet comparison program. I can develop it using python or C#. I can also include a simple GUI for selecting the files. Looking forward to hearing from you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
3.6
RealWise0702

Hello I have a courage to finish your project using excel macro. I have a deep knowledge of excel Macro and recently finished several projects using excel macro. So I'm very confident in completing your work wonder Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
2.8
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my excel vba skills. I would very much enjoy having the opportunity to t Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
2.8
mikenru1

Hi! I have experience with excel documents analysis. Not exactly that task, but very similar. Let's discuss your needs in chat.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.1
Gajacrafty

Hai this is Gajendran, I’m having good experience in Data entry work. Based on your project description I will check both excel sheet's details and provide you the best data, will complete this task within time limits. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(17 Commentaires)
3.0