So I'm trying to create a master list of all my games and organize it by having it automatically be sorted by a few criteria (platform, wishlist/owned, finished/unplayed etc.). It's just a project to improve my excel skills, so although it can be done by filtering, I want it pretty and much more readily available.
I've watched the following video to learn dynamic sub tables:
, but I have no clue why he's using SMALL and how it works. Also the INDEX function is confusing me as well.
Another thing is he's doing sub tables filtered by one variable. How can I filter by multiple variables? For example, I want a table that'll only show games for PC that are unplayed and owned, so filtered by 3 variables.
Thanks.
I've watched the following video to learn dynamic sub tables:
Another thing is he's doing sub tables filtered by one variable. How can I filter by multiple variables? For example, I want a table that'll only show games for PC that are unplayed and owned, so filtered by 3 variables.
Thanks.