Đã hoàn thành

Add missing data to cells from duplicates in Excel

Add missing data to cells from duplicates in Excel

Rows 2 to 1925 are related to our current database. We have new records, from row 1786 (the company name column value is Thunkable) to row 4633 which is the end of the sheet. There are duplicates regarding the company name. We want to add records that are not duplicated to our current database (below row 1925) and fill out empty cells in our current database with related data in duplicated records if there are any. To do so, here are the steps:

Start from row 1925. Check the company name. If there is a record with the same value in rows 2-1925, check which cells are empty in that row.

Then for each empty cell check if there is any data in duplicated row and copy it to the cell.

Else, If the company name is not duplicated, add the whole row below the last row of the current database.

Repeat the same for the next row.

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Visual Basic, Microsoft Access

Về khách hàng:
( 106 nhận xét ) Bochum, Germany

ID dự án: #33727580

Được trao cho:

(232 Đánh Giá)
6.7

242 freelancer chào giá trung bình€113 cho công việc này

(360 Nhận xét)
8.9
(437 Nhận xét)
8.6
(685 Nhận xét)
8.4
(1056 Nhận xét)
8.3
(1009 Nhận xét)
8.4
(380 Nhận xét)
8.3
(298 Nhận xét)
7.9
(536 Nhận xét)
7.9
(446 Nhận xét)
8.1
(159 Nhận xét)
7.5
(439 Nhận xét)
7.6
(333 Nhận xét)
7.4
(215 Nhận xét)
7.5
ujjwalmalik

Hi There, I have over 5+ years of experience in advance excel. I have understood the task. I am ready to start the work right away. Waiting for your response! Regards, Ujjwal

€100 EUR trong 1 ngày
(100 Nhận xét)
7.6
(338 Nhận xét)
7.2
khushh07

Hello Greetings to you!! I am an Excel (Macro)/Visual Basic and Microsoft Access expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a Thêm

€75 EUR trong 2 ngày
(363 Nhận xét)
7.4
ZAZwork

Dear Sir, I read your Job description and see that, you are looking for data entry specialist. I can do that in a meaningful way. Best Regards Khadija

€250 EUR trong 7 ngày
(148 Nhận xét)
7.5
(97 Nhận xét)
6.8
(71 Nhận xét)
7.0
daniyal3214

I can perfectly assist you with that. I am a professional Excel expert holding years of experience. I will be happy to discuss in detail.

€40 EUR trong 1 ngày
(181 Nhận xét)
7.1