when me remove the duplicates from the codes, are we not going to lose some data since the codes are from different years

Hi! We are not going to lose data, as unique entires remain in place. And in this way we are collecting all possible codes - none of them is lost, it is just that we have unique entries. Best, Ned

Since the original data stays in the 3 sheets (for each year), we don't lose it. The database just creates entries for each unique code and when we complete the table, each unique code searches its references in the 3 year-sheets. This way the table gives values (in the year columns) to each unique code for each of the year sheets it was present in. This lecture clears it up: "Use Sumif to Complete the Database Sheet"

back

Follow this topic

Madum Mac-Obegba

Last answered:

January 08, 2021

Posted on:

April 11, 2020

Create a Database in introduction to Excel

2 answers ( 0 marked as helpful)

Ned Krastev

Posted on:

April 12, 2020

Eva Sipulova

Posted on:

January 08, 2021

Submit an answer

Content