Comparing Two worksheets in Excel

Ukończone Opublikowano Oct 17, 2014 Płatność przy odbiorze
Ukończone 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.

Excel Microsoft Access PHP Architektura oprogramowania Visual Basic

Numer ID Projektu: #6605209

O projekcie

50 ofert Zdalny projekt Aktywny Oct 17, 2014

Przyznany użytkownikowi:

zebracaro

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

$250 USD w ciągu 3 dni
(125 ocen)
7.1

50 freelancerów złożyło ofertę za $366 w tym projekcie

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 Więcej

$250 USD w ciągu 2 dni
(745 Oceny)
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 Więcej

$300 USD w ciągu 2 dni
(101 Oceny)
7.4
zExcel

A proposal has not yet been provided

$253 USD w ciągu 2 dni
(269 Oceny)
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 Więcej

$333 USD w ciągu 3 dni
(232 Oceny)
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 Więcej

$250 USD w ciągu 3 dni
(175 Oceny)
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 Więcej

$250 USD w ciągu 3 dni
(108 Oceny)
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 Więcej

$250 USD w ciągu 0 dni
(196 Oceny)
6.7
dmitriy1980

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

$277 USD w ciągu 3 dni
(29 Oceny)
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 w ciągu 3 dni
(248 Oceny)
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 w ciągu 0 dni
(101 Oceny)
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 w ciągu 10 dni
(43 Oceny)
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 Więcej

$250 USD w ciągu 2 dni
(51 Oceny)
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 Więcej

$250 USD w ciągu 2 dni
(63 Oceny)
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) • Więcej

$250 USD w ciągu 4 dni
(42 Oceny)
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 w ciągu 2 dni
(6 Oceny)
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 Więcej

$250 USD w ciągu 2 dni
(71 Oceny)
5.4
westry

A proposal has not yet been provided

$250 USD w ciągu 4 dni
(22 Oceny)
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 Więcej

$250 USD w ciągu 3 dni
(43 Oceny)
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 Więcej

$250 USD w ciągu 3 dni
(30 Oceny)
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 w ciągu 0 dni
(56 Oceny)
4.5