Sedang Disiapkan

Filter some data on excel to take out double ups

I have a data analysis task.

We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in Excel documents.

There are approximately 19000 USA entries between 6 documents (7500, 11000, 28, 180, 150, 120) I think .

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

· We need to combine these lists into a master list with all the information in matching columns.

· We need to eliminate multiples of the same businesses that have the same email address.

· Create 3 pages within the document. One with all the unique listings, one that has email addresses for all listings, and one that has mailing or physical addresses for each listing.

· The Canadian lists are contained within the USA documents and need to be separated out into a Canada list document.

In Australia we have about 7000 listings over 5 documents and we need to do exactly the same with those as for the USA lists.

I also need the contacts pulled from all customers in USA and canda [login to view URL]

Kemahiran: Analisis Perniagaan

Lihat lagi: excel double data entry, combine data excel files, combine sheet data excel, combine data excel file worked different people, filter data excel using vba, combine access data excel data, vba excel filter data sum colum, filter data excel macro, filter data excel script, listing events referring data excel, excel filter data export, filter program export data excel, vba combine data excel worksheets, filter data excel template, excel filter data multiple sheets, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, vba code to filter data in excel, excel filter data based on cell value, how to filter data in excel using macro, how to filter data in excel using uipath

Tentang Majikan:
( 14 ulasan ) tuggerah, Australia

ID Projek: #20337560

Dianugerahkan kepada:

pjlnel

Dear Sir or Madam, I am a South African based professional Accountant with a proven track record. My qualifications include a post graduate degree in Management Accountant with my main subjects: Cost Accounting Advan Lagi

$30 USD dalam 2 hari
(1 Ulasan)
1.0

4 pekerja bebas membida secara purata $36 untuk pekerjaan ini

andriphone0

Hello there, Please send me message. I will provide a sample for you to prove our ability before awarding. I have gone through your requirements and ready to work. I will follow all instructions and if you have any qu Lagi

$60 USD dalam 3 hari
(0 Ulasan)
0.0
naimagul

Hi, I am an expert in Excel having vast data analysis experience using spreadsheets. I am proposing my services for the task. Let's talk about the project a bit more. Please message me. You have mentioned that data i Lagi

$25 USD dalam 4 hari
(0 Ulasan)
0.0
zohaibhassan87

Hi, I have strong knowledge in advance excel i have design many dashboard in my organization also i have provided best solutions in excel for any project. Currently im doing a job as a Associated Manager Application S Lagi

$30 USD dalam 2 hari
(0 Ulasan)
0.0