excel 2016 - filtering 2 rows in wksht from 2 different tables
hi experts i have 2 tables on the 1 worksheet, 1 under the other & i need to filter row 2 from the 1st table & row 21 from 2nd table but the filter function only lets me filter 1 row not 2, how do i filter 2 rows?
With actual data tables, each table can have their own filter; with standard range/list you can only have one AutoFilter range per sheet.
I assume it is the same sheet you sent for the Conditional Formatting question. If so, data tables can't have multiple header rows, like you have for some of your columns, eg Door Handling