Закрыт

Compare two exel tables looking for identical values.

Hi Freelancers,

I need help to ompare two exel tables looking for identical values.

The rungs of two columns are texts and numbers, and among these are the ID codes (example: Xf86Gfs).

I need the program to extrapolate these codes from the columns, compare them and return the result of the comparison, for example:

Phase 1)

The line A1-D (example) of excel contains the following text

"Transfer with id: Xf86Gfs"

Phase 2)

After the program has extrapolated the code it compares it with the second excel sheet, looking for "Xf86Gfs".

Phase 3)

At the end of the comparison, the program must give me the result of the comparison:

a) the compared rows that contain the identical code.

b) the lines of sheet 1 that do not have identical values ​​in sheet 2

NOTE

it is possible that in a row there are two values ​​to be extrapolated and compared, for example:

The A1-D line of excel contains the following text "Transfer with id: Xf86Gfs on behalf number M45ssKL"

in this case I want the program to extract two codes: "Xf86Gfs" and "M45ssKL"

How does the program extract these codes?

Or the programmer suggests it or by following the procedure below:

1) Select the first row of column X

2) Extrapolate the text in search of the words that precede the code to compare, so if the sentence contained in the line is "Transfer with id: Xf86Gfs on behalf number M45ssKL", then the program must look for the word "Transfer with id:" and then select the 7 words / number / symbols that follow

3) In this way the code "Xf86Gfs" will be processed

4) Repeat steps 1-2-3 for all lines.

I wait for serious and interesting proposals for a long-term collaboration, thank you.

Thanks

Tarek

Квалификация: Ввод данных, Обработка данных, Excel, Архитектура ПО, Visual Basic

Показать больше compare tables using excel macro, excel macro compare tables, compare excel tables, how to compare two excel sheets for differences in values, how to compare two columns in different excel sheets using vlookup, compare two columns in excel for differences, how to compare two excel sheets using vlookup, compare two columns in excel using vlookup, how to find duplicate values in different excel sheets, excel find matching values in two worksheets, compare two excel sheets and highlight differences, format tables good looking, good looking excel tables, compare tables net access sql, professional looking graphs tables, compare property values zillow cyberhome eppraisal, good looking powerpoint data tables, good looking tables word, php mysql compare tables, marco compare tables

О работодателе:
( 0 отзыв(-а, -ов) ) Salvaterra, Italy

ID проекта: #18213440

64 фрилансеров(-а) в среднем готовы выполнить эту работу за €107

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Compare two exel tables looking for identical values.. I can assure you the quality job. I have good experience in Data Entry, Data Processin Больше

€150 EUR за 2 дней(-я)
(334 отзывов(-а))
7.9
asin1987

Dear Employer, I have read your requirement and I will do your job. Please message. I am an excel expert and will do the job for you. Please do try me once!! :) Thanks and Regards, Ash

€200 EUR за 7 дней(-я)
(177 отзывов(-а))
7.5
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. I reviewed your brief and what you ask is straight-forward. You have even mentioned the algorithm to check for I Больше

€140 EUR за 2 дней(-я)
(197 отзывов(-а))
7.1
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agr Больше

€200 EUR за 2 дней(-я)
(127 отзывов(-а))
7.3
motiur03

Dear Hiring Manager, You may see my profile here: https://www.freelancer.com/u/motiur03.html I have extensive knowledge of using MS programs such as Spreadsheets, PowerPoint, Excel, data scraping and Word along w Больше

€30 EUR за 1 день
(291 отзывов(-а))
7.5
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Больше

€100 EUR за 3 дней(-я)
(223 отзывов(-а))
6.9
koolsidz

NOTE: This is a temporary bid. Please share exact details so that I can give you an exact bid My Credentials: 20+ of VB Experience. [login to view URL] [login to view URL] Больше

€88 EUR за 2 дней(-я)
(178 отзывов(-а))
6.6
logos104

Hi. I have about 15 years of programming experience. Among my projects there are a lot of tasks for Excel files automated processing. I can develop simple standalone application that takes XSLX file, make necessary Больше

€222 EUR за 3 дней(-я)
(94 отзывов(-а))
6.5
dgled

Hi I did some similar projects to find similar expressions in 2 tables and to point on double similar words (like family name email address etc) I am a financial expert and guru in Excel/VBA/Macro. I have extensive Больше

€200 EUR за 3 дней(-я)
(72 отзывов(-а))
6.9
macroPOL

Hello, I am Excel and VBA expert. I can do this project (VBA macro). If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Больше

€100 EUR за 3 дней(-я)
(94 отзывов(-а))
6.0
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfe Больше

€155 EUR за 3 дней(-я)
(76 отзывов(-а))
6.2
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you Больше

€98 EUR за 3 дней(-я)
(112 отзывов(-а))
6.3
sloker18

I am proficient with excel macro/VBA development, I can write the macro to do the comparison as requested, if you are interested feel free to message me, I am available to start your project immediately, looking forwar Больше

€100 EUR за 3 дней(-я)
(68 отзывов(-а))
5.5
abdolah2014

hello I am an excel-vba expert and I can finish your project so fast start the chat I am ready to start.........................................................................................

€111 EUR за 3 дней(-я)
(39 отзывов(-а))
5.4
AkilaArun

Hi, I am interested in taking up this task. Have read through all the lines carefully and understood the requirement. I have over 5 years of Experience working with Excel tasks and can complete tasks with accuracy Больше

€70 EUR за 2 дней(-я)
(38 отзывов(-а))
5.0
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Больше

€155 EUR за 3 дней(-я)
(32 отзывов(-а))
4.9
ilkecokay

Hello sir. Excel expert here. I have prepared exact similar projects as this one before with 100% accuracy. And i must say, IT IS EASY! Please do not spend 100-150€ on this one! Sir, even if you don't have coding kn Больше

€50 EUR за 1 день
(46 отзывов(-а))
5.0
mtdevil369

Hi, I am having good knowledge on excel,micros and VBA module development. Please come on freelancer chat to discuss many more on this project as I am able to do the same.

€47 EUR за 0 дней(-я)
(94 отзывов(-а))
5.5
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can create Excel vba macro to accomplish the requirements which you described. Macro will take Больше

€120 EUR за 3 дней(-я)
(78 отзывов(-а))
5.4
einnovention

Dear Sir, We have specialised and dedicated team for Microsoft excel, powerpoint and word as well, you can discuss further whatever you want specifically for excel. Looking forward! Kami

€150 EUR за 3 дней(-я)
(6 отзывов(-а))
4.4