Compare two exel tables looking for identical values.

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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

Data Entry Data Processing Excel Software Architecture Visual Basic

Project ID: #18213440

About the project

58 proposals Remote project Active 5 years ago

58 freelancers are bidding on average €109 for this job

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 in 7 days
(343 Reviews)
8.5
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 More

€150 EUR in 2 days
(646 Reviews)
8.6
ParisPallas

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 More

€140 EUR in 2 days
(614 Reviews)
8.7
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 More

€30 EUR in 1 day
(400 Reviews)
8.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 More

€200 EUR in 2 days
(222 Reviews)
8.1
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 More

€100 EUR in 3 days
(177 Reviews)
7.6
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 More

€200 EUR in 3 days
(96 Reviews)
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 More

€100 EUR in 3 days
(342 Reviews)
7.5
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 More

€155 EUR in 3 days
(103 Reviews)
6.9
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 More

€222 EUR in 3 days
(106 Reviews)
6.8
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. More

€100 EUR in 3 days
(98 Reviews)
6.2
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 More

€120 EUR in 3 days
(147 Reviews)
6.2
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 in 3 days
(13 Reviews)
5.9
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 More

€70 EUR in 2 days
(56 Reviews)
5.7
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 More

€98 EUR in 3 days
(113 Reviews)
6.3
bktk

hi sir I am expert of comparing two column in excel on urgent basis along with unlimited revision and free sampling sir let's discuss further .

€30 EUR in 1 day
(162 Reviews)
5.8
paulodayto08

Hi Good Day! A serious freelancer here! I can help you to complete this project in 1-2 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take More

€30 EUR in 2 days
(79 Reviews)
5.5
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 More

€155 EUR in 3 days
(34 Reviews)
5.3
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 in 3 days
(39 Reviews)
5.4
Ahmed818

Hello, i am ready to write the vba code to compare the 2 sheets data waiting your answer Thank you

€30 EUR in 1 day
(107 Reviews)
5.3