Compare two exel tables looking for identical values.
€30-250 EUR
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
Project ID: #18213440
About the project
58 freelancers are bidding on average €109 for this job
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
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
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
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
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
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
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
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
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 .
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
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
hello I am an excel-vba expert and I can finish your project so fast start the chat I am ready to start.........................................................................................
Hello, i am ready to write the vba code to compare the 2 sheets data waiting your answer Thank you