Handle duplicate removals in huge excel files

€8-30 EUR

Κλειστή

Αναρτήθηκε

πάνω από 7 χρόνια πριν

€8-30 EUR

Πληρωμή κατά την παράδοση

So we have huge excel files in various formats that we sometimes must double check against each other and remove duplicates from file A that exists in file B. In short we put all the info that will be matched in column A in both files. Then we use to run a MACRO but it takes hours for huge files so we need a better solution. Maybe access or similar? The files can have different amount of columns from time to time but column A will ALWAYS have the info that will be matched. So File A) is matched against file B) and the output file will be file A) with all the UNIQUE rows intacs. In other words all the rows that file B) has that matches with file A) are removed from file A) And the rest is output. I need this done ASAP since we have a file of 1,5 million rows that we need to match agains a file with about 200k rows and I can't use a macro for that since it's too slow.

Excel

Microsoft Access

Ταυτότητα εργασίας: 12186692

Σχετικά με την εργασία

58 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

58 freelancers δίνουν μια μέση προσφορά €36 EUR για αυτή τη δουλειά

@asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on skype as well: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.

€23 EUR σε 1 ημέρα

5,0

(182 αξιολογήσεις)

7,6

@sy3d

we can add match/index formula and it will highlight duplicate rows, so we can remove those please share files, i'll show demo before you hire me thx

€35 EUR σε 1 ημέρα

4,9

(288 αξιολογήσεις)

7,3

@oadsmedia

!!! Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss............. Choose wisely!! Cheers :)

€29 EUR σε 0 ημέρα

5,0

(74 αξιολογήσεις)

6,5

@zolayossa

Do you need a one time matching or a code solution? If you want a one time duplicate removal, I can start right away and give you output in an hour.

€23 EUR σε 1 ημέρα

4,9

(150 αξιολογήσεις)

6,4

@macroPOL

Hello, I am Excel and VBA expert. I can create very fast macro. You have a very slow macro. I have a way to make my macro work very fast. I have just done tests on my data. For two files (each about 1 million rows) the time required to compare these files is about 1 minute. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

€39 EUR σε 0 ημέρα

5,0

(93 αξιολογήσεις)

6,0

@gayuh

Hi! I would like to offer my service to handle removal of duplicate rows in the huge excel files. I think the macro you have is not optimized enough to work with the huge number of data, hence the slow performance. If you share the macro, I can have a look at it, and see whether an optimization would result in much better performance, or not. Looking forward to hearing from you. Thank you.

€30 EUR σε 1 ημέρα

4,9

(98 αξιολογήσεις)

6,1

@dpune

Hi, I have more than 14 years of Visual Foxpro exp and I am expert in this kind of work. I can build this using Visual foxpro which will be pretty quick. not sure how long macro is taking now ? I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

€30 EUR σε 3 ημέρες

4,9

(117 αξιολογήσεις)

6,2

@richkumar

Hello, I have experience in excel, data entry work. I can remove duplicate. Please check my portfolio. I can do this project with accuracy. I am ready to start Now. Please review my bid. Thanks. Rich

€19 EUR σε 1 ημέρα

5,0

(108 αξιολογήσεις)

5,9

@narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 6 years of experience. I have successfully completed few projects for US clients which involved web scraping, web research,internet research and data entry. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) High quality data 4) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards

€34 EUR σε 3 ημέρες

4,9

(39 αξιολογήσεις)

5,7

@priteshkhande88

I am a skilled freelancer who has a working experience of more then 4 year I have working experience on- Web Research, lead generation, data entry, data mining, lead collection, All types of scrapping tools like - data toolbar, web hearvy, VWR etc..... I have great experience that would fit best. if hired by you i will deliver work of high standard and provide exceptional contribution in serving your task.

€9 EUR σε 1 ημέρα

5,0

(40 αξιολογήσεις)

5,5

@MoohHHooM

Hi, i can help you with this project, please let me know more about it :) i may fix your macro so you will get same results in less time, or i will create a tool in VB.NET that can handle this amount of rows in super fast time.. .

€29 EUR σε 10 ημέρες

5,0

(26 αξιολογήσεις)

5,3

@pm9887

Hi, I have vast experience in Lead Generation, Data Entry and Data processing. You can check my competencies. I can give you the best quality in quick turn around time with the good competitive price. Thanks

€14 EUR σε 3 ημέρες

4,9

(62 αξιολογήσεις)

5,6

@KarnMukesh

Hi, Hope you are doing well. I have reviewed the project description and able to start this task which require to check huge excel files of various formats and remove duplicates from file A that exists in file B according to the below given instruction. File A) is matched against file B) and the output file will be file A) with all the UNIQUE rows intacs. In other words all the rows that file B) has that matches with file A) are removed from file A) And the rest is output. I make sure you that I will complete this task with high accuracy and on budget and on time as well Regards Mukesh

€25 EUR σε 1 ημέρα

4,8

(62 αξιολογήσεις)

5,3

@tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

€100 EUR σε 1 ημέρα

4,8

(89 αξιολογήσεις)

5,3

@rumarahman

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Finance Management Statistics Data Processing Data Collecting (Using Macro) MS Office C++ HTML VBA Mathematics Excel VBA Macro Automation User Forms Data Analyzing PivotTable Chart Graphic Presentations Data Presentations And any task related to Excel Feel free to contact me.

€30 EUR σε 1 ημέρα

5,0

(39 αξιολογήσεις)

5,2

@Bestever786

Hello dear sir how are you hope you are well Dear sir if you really want 100% Error Free and Quality Data Research and Data Entry Work done Manually or By Tool (Code) Then Please Hire me for this Data Entry Job Thanks

€30 EUR σε 3 ημέρες

4,7

(20 αξιολογήσεις)

5,0

@crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.

€30 EUR σε 2 ημέρες

4,9

(29 αξιολογήσεις)

4,4

@insidenetsoft

Hi, I'm making some optimizations test in my local environment with big files like yours and I get a decent time. Can you please send some sample files? I bid only 30$ because this is more like a challenge for me and I'm interested more in delivering quality for a good review than the money. Best regards, Marius Avram

€30 EUR σε 1 ημέρα

5,0

(27 αξιολογήσεις)

4,4

@chintu83

Lest's start work with great accuracy and with in time deadlines .My aim is to satisfy my client by my WORK.Thanks.

€12 EUR σε 1 ημέρα

4,9

(16 αξιολογήσεις)

3,8

@kanshowen

Hi ! This Can be done need to know both excel file data size means how much MB or GB. i Can do in Access if the File size less than 2 GB or this to be tried sql . Kindly contact me though PM if you like to see the solution . Looking forward message from you .

€29 EUR σε 1 ημέρα