Consolidate Spreadsheet of Names and Email Addresses.

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

I have 2 spreadsheets - Spreadsheet 1 and Spreadsheet 2.

For any person listed in Spreadsheet 1 that is also listed in Spreadsheet 2, I need someone to add the email address and patient id number in spreadsheet 2 for the person listed in Spreadsheet 1.

Also, in Spreadsheet 1 the First name column includes the last name for some entries and the word "count". Need that to be deleted. When done, would like the final spreadsheet (Spreadsheet 1) to be arranged by Last Name. Then would like a second sheet on the same work book that only lists the patient for which an email address was found and then another sheet that list the patient names for which no email address was found on Spreadsheet 2.

You may not add any person from Spreadsheet 2 onto Spreadsheet 1 unless the name is on Spreadsheet 1. Spreadsheets are attached so you can review and ask questions. PLEASE MAKE SURE THAT THE FINAL SHEET IS SPREADSHEET 1.... Spreadsheet 2 is the list of names that might have a corresponding email address and Id number for the people listed in Spreadsheet 1. There will be people in Spreadsheet 1 that are not listed on Spreadsheet 2, and thus you will not be able to insert an email address or id number.

Data Entry Data Processing Excel Web Search Word

Project ID: #15844764

About the project

13 proposals Remote project Active 6 years ago

Awarded to:

samerziadeh

A proposal has not yet been provided

$35 USD in 1 day
(1 Review)
1.1

13 freelancers are bidding on average $92 for this job

Innovative116

Hi there. I am a full time spreadsheet expert. I checked attach spreadsheet. Cross checking two spreadsheet and formatting spreadsheet 1 as explained will be done within 24 hours. Best, Harish Relevant Skills and Expe More

$150 USD in 1 day
(316 Reviews)
8.2
KulfiSoftwares

I love excel. Can start immediately and finish within a couple of hours.. Have done similar work before. Have seen your spreadsheet, and understand the requirements very clearly. Relevant Skills and Experience Please More

$50 USD in 0 days
(211 Reviews)
7.1
P0L

Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards. Stay tuned, I'm still working on More

$100 USD in 1 day
(227 Reviews)
6.9
hdlong66

Hello, You need to consolidate spreadsheet of names and email addresses. I'm ready to start immediately. Best regards, Hoang Relevant Skills and Experience I have completed 6 similar projects in the past Proposed Mil More

$50 USD in 2 days
(128 Reviews)
6.8
bd100m

I am ready to start now. I am fully available. ........................... Waiting to get hired soon! Relevant Skills and Experience .... Proposed Milestones $155 USD - ....

$155 USD in 3 days
(121 Reviews)
6.8
sadikonline

Hi, I am expert in Excel spreadsheet. I can transfer data one spreadsheet to another spreadsheet properly. Looking forward working with you. _ Sadiqur Relevant Skills and Experience Data Entry, Excel Proposed Milest More

$50 USD in 3 days
(90 Reviews)
6.1
habib400605

I will get your project done within your required deadline. i have done another job like this a week before. So you can give this project if you want to get you job done with 100% accuracy

$100 USD in 4 days
(3 Reviews)
0.8
aminayousaf2

Hi, I am expert in MS Excel, I can do your task very quickly and fast. I will deliver you professional work on time with 100% accuracy. We can discuss detail in chat. Hire me Relevant Skills and Experience I have More

$50 USD in 1 day
(1 Review)
0.5
IonelAun

A proposal has not yet been provided

$222 USD in 3 days
(0 Reviews)
0.0
elainethompson69

Over 20 years' experience in spreadsheets and Excel, excellent data entry, data processing and web search skills, 100wpm+ typing speed, 100% accuracy, proficient in Excel and Word Relevant Skills and Experience Over 2 More

$155 USD in 3 days
(0 Reviews)
0.0
gurbanirohan

A proposal has not yet been provided

$45 USD in 2 days
(1 Review)
0.0
rothinww

Hi dear how are you?I saw your project and read details.I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Relevant Skills and Experience Data Ent More

$30 USD in 3 days
(0 Reviews)
0.0