Excel 2016 Automated Task
$30-250 USD
Πληρώθηκε κατά την παράδοση
I will be posting this for the third time. The last two coders could not provide assistance and I lost money.
I request the following:
READ THOROUGHLY
1. An automated way to compare two sets of data and remove duplicates in Excel 2016.
2. It must be a working sample for me to approve paying you. I have already paid two coders prior to completion with nothing to work with. I WANT YOUR WORK FOR ME TO APPROVE FIRST.
3. I am looking for all english instruction and english workbook to be used, in Excel 2016.
This is simple for someone expert in Excel 2016.
Don't waste my time if you cannot do this task or I will rate you accordingly.
I have been a buyer on here for 10 years or more and have an excellent rating.
See below for original instructions from previous two bids but will have Excel 2016:
I have some work, in an Excel spreadsheet... I'm limited to a i3 processor with 8gb RAM. I only have Excel 2016... I need to do the following:
One database is approx. 850k rows of two columns of data. Email Address and State.
Match that set of data against a suppression list of just email addresses, which amount to 80k approx.
So data would be:
Data Set A: 800,000 - 900,000 rows of 2 columns - email address and state
Data Set B: 80,000 - 100,000 rows of 1 column - email address
Compare B to A and remove any that are duplicates in Set A including the associated state in second column.
Design a worksheet in Excel 2016 where I can paste the 800-900k rows and 2 columns into, and calculate against second set of 80k rows of only 1 column. Then remove any from 2nd set from the 1st set, including the second column associated.
Thanks .. need this right away.
Ταυτότητα Εργασίας: #18049004
Σχετικά με την εργασία
Ανατέθηκε στον:
Hi.. I can strat working right away. I can create a macro to compare the 800-900k rows set with the 80k rows set and remove the rows that are not in the 80k rows set and then remove any duplicate row in the resulting s Περισσότερα
9 freelancers κάνουν προσφορές κατά μέσο όρο $115 για αυτή τη δουλειά
Hello? How are you? I have good skills in Excel vba and macros.... So I can complete your job in time. Hope to work with you. Thank you.
Good Day, I am willing to take responsibility for your project too! Please let me know, if you want my services. Thanks Emamul H.
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.
Hi, First of all I have a question about your project, you need an VBA script that will verify each email from the 2nd file if it is already in 1st file, if yes the row with it has to be deleted (email and state), am Περισσότερα
Dear sir! I'm seeing your project details. I have good experience with this task. I'm ready to start now. Can you please contact me so we can chat more for this task. Thank you
I can do what you need. The best approach for this is to use Excel features in VBA so the process is easy and efficient. Advanced filters in VBA tend to be very effective when managing large amounts of data. Please do Περισσότερα
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.
I can help you with this sheet. I will provide the file by tomorrow evening. I will be working on office 365. I am 100% sire same is supported by office 2016. Thank you for reading my proposal. Regards, Shrikant Kumar Περισσότερα