How to Filter non-contiguous Columns
I have a worksheet where column A contains names. Columns B:AF can be blank or contain a integer 1 - 31. Column AG sums each row. THEN, Columns AH:BL contain the same as noted for Columns B:AF and Column BM contains the sum of each row between AH:BL.
What I'm trying to do is filter Columns A:AF where AG is <0. This I can do without a problem.
I'm stuck at the moment trying to filter Columns AH:BL where BM is <0 AND include Column A in this filter.
Not looking to do this all at once as I'm happy to run two filters or what-have-you. I just need to have Column A included in the 2nd Filter pass.
Not even sure this can be done with a filter so, that's why I'm posting here.
|