• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Having trouble figuring out how to create dynamic sub table off a master list

anubomb

New Member
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.
 

Attachments

  • Master List.xlsx
    15.2 KB · Views: 1
Back
Top