Đã hoàn thành

Extract data from 17 excel documents and create master file with filter criteria (need done today)

Please let me know if you can do this within 24 hours.

Before copying data to main excel sheet-

1. Delete all rows that contain following keywords in company name, website, or email: Farmers, progressive, insurance, geico, university, school, academy, foundation, nonprofit, kinder, welch, waldorf, college, and .edu.

2. Copy all rows into the master document that contain one of the keywords in the “Job Title” column: partner, founder, owner, lawyer, attorney, marketing, intake, reputation, sales, shareholder, director, president, and manager.

After all cities are copied to main data sheet

1. Delete duplicates (determined by email)

2. Delete all rows that do not contain an email address.

3. Save as both xlsx and csv format.

4. Name the state name. For example, “Pennsylvania law firms”.

Kĩ năng: Excel, Xử lí dữ liệu

Về khách hàng:
( 10 nhận xét ) El Dorado Hills, United States

ID dự án: #34313631

Được trao cho:

roksanaripa1993

Hello Sir, I have done many virtual assistant projects, data entry and web scraping before. You can review my profile and see my clients feedback. I am ready to start right away. I am fast learner. I am familiar Thêm

$20 USD trong 1 ngày
(161 Đánh Giá)
6.8

25 freelancer chào giá trung bình$31 cho công việc này

(1304 Nhận xét)
9.2
(392 Nhận xét)
8.1
(278 Nhận xét)
7.1
(258 Nhận xét)
7.3
(221 Nhận xét)
6.8
(127 Nhận xét)
6.5
(63 Nhận xét)
5.3
(38 Nhận xét)
5.1
AAGGMM

Hello sir I am Ahmed, a GOOGLE certified data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming languag Thêm

$30 USD trong 1 ngày
(46 Nhận xét)
4.9
Dataservice429

Hello, We are a Professional Deep Data Miner, Data Scraping, Data Entry Operator and Lead Generation expert in since 5 years. We carefully read your project description. We learn that you need to Extract data from 17 Thêm

$10 USD trong 1 ngày
(7 Nhận xét)
4.6
MamukaB

hello I can do this project very quick. Maybe within few hours I think is possible to do all 3 month data together I will do it using Excel VBA . It's very powerful app for like this cases I have 15+ year experience o Thêm

$30 USD trong 1 ngày
(32 Nhận xét)
4.5
(9 Nhận xét)
4.2
(26 Nhận xét)
4.2
(8 Nhận xét)
4.3
(10 Nhận xét)
4.1
(15 Nhận xét)
4.3
Maherun75

"Dear employer, I had read your requirement for Extract data from 17 excel documents and create master file with filter criteria. I am expert in this field. That's why I placed my bid on this project. I'm a professiona Thêm

$100 USD trong 1 ngày
(13 Nhận xét)
3.6
(5 Nhận xét)
2.5
(3 Nhận xét)
1.4
AsmaBaloch3

""""""""""""""""""""""" I AM READY TO START THE WORK RIGHT NOW! """""""""""""""""""""""""""" Hello Sir/Ma'am I understand your project description. I think you are looking for someone for your project who can Extract d Thêm

$10 USD trong 1 ngày
(2 Nhận xét)
0.8