Fermé

Sort and reformat excel spreadsheets and remove double ups.

1. We need this job started as soon as it’s assigned and completed within 48 hours of being assigned. If you can’t do this and if you are a poor communicator, please don’t bid for the work.

2. We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in 18 Excel documents. In the name of each excel document is the country it’s from. Estimated entries are USA 19,000, Australia 7000 and Canada 5000

3. We need 3 documents, one for each country. One page per document

4. Each of these documents is currently formatted differently so the information is in different columns and they are in different stages of completion.

4. We need to combine these lists into a master list. One for each of the 3 countries with all the information in matching columns.

6. The information we require is the Business name, email address, website, street address, suburb, state, postcode/zip, mailing address, phone number, contact person, contact person’s mobile phone, contact persons position, company type.

Not all this information will be available for every entry, but the available information must be included. Only information for the columns above is required, others information can be ignored.

7. We want one entry per physical address or unique business, all the double up’s need to be removed. Where only email addresses are present, include them if they are not already in listed on another line.

11. For both Australia and the USA, there is an unsubscribed list which must be filtered out of the email column only. The email address should be substituted with “unsubscribed”

Compétences : Saisie de Données, Traitement de Données, Excel, Web Scraping, Recherche sur Internet

en voir plus : how to find duplicate values in excel using formula, how to remove duplicates in excel 2016, how to find duplicate values in different excel sheets, remove duplicate rows in excel, excel remove duplicates not working, how to remove duplicates in google sheets, how to find duplicate values in excel using vlookup, how to identify duplicates in excel, designing excel spreadsheets, bowling tournament excel spreadsheets, reformat excel spreadsheet, convert pdfs excel spreadsheets, proficient excel spreadsheets, business plan free excel spreadsheets, creative excel spreadsheets, reformat excel spreadsheet database format, bookkeeping excel spreadsheets, reformat excel files, accounts receivable excel spreadsheets, basic job description excel spreadsheets

Concernant l'employeur :
( 0 commentaires ) Mumbai, India

Nº du projet : #20846972

69 freelance font une offre moyenne de $420 pour ce travail

dfexcel

Hi, Based on my expertise in Excel advance formulas, I can complete this job with a quick turnaround. I would appreciate if we can get onto a Skype call to discuss further details. Thanks, DC

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)
5.3
razvancotofana

Hello, I have a solid data entry and processing experience and I would be happy to assist you with your project. Please share the files over chat. BR, Razvan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(18 Commentaires)
5.3
bhupendrayadav

I have understood the requirement of merging the data from 18 files into 3 files one for each country in specific format with duplicate removal, i can deliver it in next 48 hours. Please find below a brief introduction Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(32 Commentaires)
5.1
srijanagrawal21

Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of DASHBOARDS, FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(25 Commentaires)
3.9
JulijanAndjelic

Hi there, Thanks for the rather clear project description, that's a true gem these days. Ready to start as soon as awarded, given it's not night in GMT+2, and should be able to finalize within 24h. I would do this ta Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
3.5
StephanEdwards

I have consolidated data-base lists of 70k customer details before. I use standard excel automation tools to process and quality assure the data. I will have your sheet completed as a new Excel model in 48 hours. I pro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
3.0
elepsis

Hi there, I am ready to start and will have the work done in less than 48 hours of project being assigned to me. I will have all the 18 excel sheets converted into there respective master excel file, based on there co Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
2.5
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
2.7
samobot

"I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrie Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
2.5
jain602

Hi How are you? Share more details about your Project. Well as per the description work can be done but still I would like to know more details about the project. Please, checkout some of my recent Websites links: Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(3 Commentaires)
2.2
jindalforever

Best candidate for u ,if u don't believed then try it, do the project within your budget,price,time with expertise,do many similar projects. -I am :chartered Accountant(ACCA/CPA) :Laywer :Masters in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(5 Commentaires)
2.3
khaldalfalah

Hi, I have experience in Excel, MS SQL server and VB.net more than 12 years, and ready to start on your excel files. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
1.3
reddyvvkr

New freelancer and able to do work Relevant Skills and Experience Have Knowledge in Excel

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
ravidatt1426

Hello SIr, I can understand your requirement and can do it for you within the stipulated time. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
Cort0926

I am very detail oriented as I manage a Medical Office and it is required of me. I type with very high accuracy at 75+ WPM and am used to working with deadlines.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
pouldizon2

Hi, I've read through each bullet point of the job and I believe I should be able to work on it by thr specified time. I would love to discuss more. Thanks, Poul

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
tcasas1

Hi! I am advanced in excel and visual basic. I already have some macros that convine different excels into one, i can adapt that to your current necesity and do all the sorting and duplicate elimination needed.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
techlinesols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.0
nazeerhusen

I am an experienced professional with Excel & other MS office suites. I can turn this project fast and within the time given. Work will be started as soon as the project is assigned.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
raoshakeel500

I have read your project thoroughly, I have a competent and hard working team for this project and abillity to complete target before given as soon as possible . so I think you should hire me for your satisfactory work Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0