Last answered:

22 Feb 2021

Posted on:

19 Feb 2021

0

Too many rows in Before sheet

I have downloaded the Before sheet for creating a database. When i copy the rows for the year 16 (58 rows) 17 (123 Rows) and 18 (111 Rows) i get 291 Rows not 215 like in the video. this means when i remove duplicates i get 150 rows and errors.
When i do the same things in the after sheet it works perfectly, have i missed something?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

22 Feb 2021

0

Hi Kelvin,
Thanks for pointing this out. This is a mistake on our end we'll fix. The version of the file that is uploaded contains the 'Totals' row, which was deleted a few lessons earlier. Please feel free to delete the row on your own or simply download the updated file. Thanks!
Best,
Ned

Submit an answer