Did you hear about the database developer that walked into a bar? They saw two tables and tried to join them.
And that's what we're doing this week! Last week, as you might recall, I posted an overly complicated solution to this problem based on formulas.
This week, I've simplified it all using a left outer join. This is a really cool feature that lets you treat Excel like a database. You can a very similar use of joins in Szilvia's video, by clicking here.
Let us know in the comments.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.