Comparing Two worksheets in Excel
$250-750 USD
Płatność przy odbiorze
Project: Comparing two worksheets in Excel
The objective is to compare two worksheets (DAS and Vendor (per attached file))
each containing Three columns (Date, Number and Duration)
Compare the two variables (Date and Number) and find the third value (Duration) from each worksheet. Note: Date format is mm/dd/YYY hh:mm:ss and it may not be exact match so provisions for a tolerance in dates should be included in a way that user can specify the tolerance in seconds.
the results should be recorded in Two new Worksheets (Matched and Unmatched).
If Duration is the same for both work sheets, the result should be in “Matched” sheet containing four columns (Date, Number, DAS Duration, Vendor Duration)
If Durations are not the same, The result should be in “Not Matched” sheet containing four columns (Date, Number, DAS Duration, Vendor Duration)
Sample file is attached.
Numer ID Projektu: #6605209
O projekcie
Przyznany użytkownikowi:
50 freelancerów złożyło ofertę za $366 w tym projekcie
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Więcej
Hi there. I have read the description and I can do the project for you in 2 days. I have previously done a very similar project in Excel before and I can manage it pretty comfortably for you. If you like, I can do the Więcej
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and databases. I am also an orderly, neat and committed person with my work. C Więcej
Hi: I have questions: Do you a program that can match the data in sheets based on the tolerance that you specify? What is the time that you have in mind for the project? Please note that I have 100% completion rate and Więcej
Hi, I will be glad to help you out with this. I have plenty of experience with Excel so I assure you an excellent work. However, I have some questions regarding your project so please contact me so we can discuss those Więcej
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Więcej
hey there, we can do this excel comparison, i think you have posted this project in a 250$+ category, we can get this done at a much lower price, please reply, thank you !
Hello, I will delier this project in 1 day for only $165 + free 90-days support offered to you! Stephane
Its Ram from India, I am ready to work on this project. I have worked on various excel and .net based project.
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contai Więcej
Hi! Your project looks quite simple for me. I have a vast experience in more complex projects, so I hope you'll be satisfied with an excellent result!
Hi, Greetings for the Day. I have 3+ years of experience in VBA and VB.net coding. I can do this task very well. Kindly message me so that we can discuss this project. In my last project i have automated the c Więcej
I can do this work, I will give you perfect document with in few hours, please consider me for this time to show my performance. Waiting for your Positive response