Terminé

Excel 2016 Automated Task

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.

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic

en voir plus : excel spread window doesnt away, excel vba automated monthly reports, excel vba automated web scrape, microsoft excel automation, macros in excel for beginners, record macro excel 2016, macros in excel 2016 tutorial, how to use macros in excel, how to automate excel reports, how to automate excel spreadsheets, excel automation tools, excel macro paste fill empty previous sheet, excel template automated, advance excel 2016, design of macros and programming in vba with excel 2016 ebay, excel 2016 power programming with vba, excel 2016 power programming with vba mr spreadsheet's bookshelf, excel 2016 power programming with vba pdf, excel 2016 programmers, excel 2016 programming

Concernant l'employeur :
( 194 commentaires ) New Orleans, United States

Nº du projet : #18049004

Décerné à:

diorisaguilar

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(39 Commentaires)
6.0

10 freelance font une offre moyenne de $128 pour ce travail

polarjin2017

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(65 Commentaires)
6.3
emamulbd

Good Day, I am willing to take responsibility for your project too! Please let me know, if you want my services. Thanks Emamul H.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(55 Commentaires)
5.9
c4cuteconain

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)
5.0
DesignerTarun04

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
3.8
afenache

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(11 Commentaires)
3.9
qingbi53

Hi there,I see you're looking for somebody who is expert in Excel. I am expert in the following MS Office,C++,C#, .NET,Software Architecture,Windows Desktop,Python,MySql,MS Sql,PHP,JAVA,HTML,CSS etc. And Also I use t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.6
CronyTech

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.8
khansajol082

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.0
kushrikant

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0