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"

Follow this topic

Madum Mac-Obegba

Last answered:

08 Jan 2021

Posted on:

11 Apr 2020

Create a Database in introduction to Excel

2 answers ( 0 marked as helpful)

Ned Krastev

Posted on:

12 Apr 2020

Eva Sipulova

Posted on:

08 Jan 2021

Create a Database in introduction to Excel

Submit an answer