I have a somewhat complex table that has multiple lists in Microsoft Excel, and I would like to filter. Additionally, I would like to have multiple filters within a single sheet, and need to specify the array that gets filtered, thus setting different values for the filter reference for each filter. Attached is a spreadsheet that hopefully will help clarify my question.