Fill Blanks

• Status: Closed
• Hadiah: $10
• Entri Diterima: 17
• Pemenang: atasoyk

Winner

Deskripsi Kontes

Hello Everyone,

The goal of the contest is to develop a tool or a code which will be able to fill blank spaces with the true value.

I am including an Excel file with two worksheets. On Worksheet 1 you will find the report that should be fixed. On Worksheet 2 you will find the table where you should look for the ID Number (Column H) of the row and find the true value for the column that is blank (highlighted in yellow in worksheet 1).

*Please be aware that the code should be able to identify the blank spaces and only replace those cells with the correct value, as the other cells which are not blank may not be the same and should not be replaced.

Thank you for participating!

Cristobal

Keahlian yang Disarankan

• Coding
• Excel VBA
• Microsoft
• Python
• Bahasa Pemrograman R