Comparing Two worksheets in Excel

Completed Posted Oct 17, 2014 Paid on delivery
Completed Paid on delivery

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.

Excel Microsoft Access PHP Software Architecture Visual Basic

Project ID: #6605209

About the project

50 proposals Remote project Active Oct 17, 2014

Awarded to:

zebracaro

i can do it for you quickly and exactly with VBA .

$250 USD in 3 days
(125 Reviews)
7.1

50 freelancers are bidding on average $366 for this job

jaylancer43

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 More

$250 USD in 2 days
(745 Reviews)
8.5
maverick44000

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 More

$300 USD in 2 days
(101 Reviews)
7.4
zExcel

A proposal has not yet been provided

$253 USD in 2 days
(269 Reviews)
7.7
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 and databases. I am also an orderly, neat and committed person with my work. C More

$333 USD in 3 days
(232 Reviews)
6.9
aarifakhtar

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 More

$250 USD in 3 days
(175 Reviews)
7.0
DanielVizcaya91

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 More

$250 USD in 3 days
(108 Reviews)
6.9
avinav606lx

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 More

$250 USD in 0 days
(196 Reviews)
6.7
dmitriy1980

Предложение еще не подано

$277 USD in 3 days
(29 Reviews)
6.3
expertatwork

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 !

$250 USD in 3 days
(248 Reviews)
6.3
stephhw01

Hello, I will delier this project in 1 day for only $165 + free 90-days support offered to you! Stephane

$250 USD in 0 days
(101 Reviews)
6.7
digidreamstech

Its Ram from India, I am ready to work on this project. I have worked on various excel and .net based project.

$555 USD in 10 days
(43 Reviews)
6.0
pishty

Hi, I am interested in your project. You can count on me for a fast and 100% accurate job done. I checked the file and compared some records by phone number. Indeed some of them do match by duration time and others d More

$250 USD in 2 days
(51 Reviews)
6.0
nagybatonyi

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 More

$250 USD in 2 days
(63 Reviews)
5.7
Grunty

Hello, Given the high number of offerents, I will try to differentiate my proposal by adding the following, on top of your requirements: • Count and Sum of durations on both sheets generated (Matched, Unmatched) • More

$250 USD in 4 days
(42 Reviews)
5.8
makarigor

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!

$250 USD in 2 days
(6 Reviews)
5.1
kher78

Hello, If you're cimploy looking to try and do this in Excel I can do for $100USD. If you are looking for a PHP solution, then I'm not a good candidate for you. I could provide you with the ability to select the f More

$250 USD in 2 days
(71 Reviews)
5.4
westry

A proposal has not yet been provided

$250 USD in 4 days
(22 Reviews)
5.3
proauthor

Dear employer, I can give you a java program that can compare the dates as per the given tolerance in both the the sheets and output the results. Hope this works for you. If you're fine with this, please let me know More

$250 USD in 3 days
(43 Reviews)
5.1
Mufaddalsaifee

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 More

$250 USD in 3 days
(30 Reviews)
4.7
saravanan87

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

$250 USD in 0 days
(56 Reviews)
4.5