I gang

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]

Evner: Forretnings Analyse

Se mere: 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

Om arbejdsgiveren:
( 14 bedømmelser ) tuggerah, Australia

Projekt ID: #20337560

Tildelt til:

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 Flere

$30 USD in 2 dage
(1 bedømmelse)
1.0

4 freelancere byder i gennemsnit $36 på dette job

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 Flere

$60 USD in 3 dage
(0 bedømmelser)
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 Flere

$25 USD in 4 dage
(0 bedømmelser)
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 Flere

$30 USD in 2 dage
(0 bedømmelser)
0.0