Forum Discussion
Can't set filter on multiple array
Reproducible Steps:
- Set two cells as arrays
- Set filter on an array
- Try to set filter on another array
- The filter doesn't set, instead, the filer set before was removed
(filter on table wasn't affected)
You can only set only one filter, from the Editing group on the ribbon, on a range of adjacent cells in the same sheet. The filter buttons in structured tables are special and are switched off or on in the 'Table style options' group on the Tables ribbon. So they are not affected by the "regular" filter option.
You can only set only one filter, from the Editing group on the ribbon, on a range of adjacent cells in the same sheet. The filter buttons in structured tables are special and are switched off or on in the 'Table style options' group on the Tables ribbon. So they are not affected by the "regular" filter option.
