Hello,
I found several examples of displaying filtered criteria on the internet; however, they don't appear to work for worksheets that contain data within an Excel table. I've tried everything and nothing seems to help. Here is my problem:
Imagine I have an Excel table with the following columns:
<tbody>
</tbody>
The table can be filtered up to "x" number of columns, but for the purposes of this example let's assume 3 columns can be filtered (see above). These filters are not necessarily active at the same time.
The Function/Formula displaying the results of each filter would be entered into a different cell(s) somewhere on the sheet.
Any help is greatly appreciated!
TIA
Jay
I found several examples of displaying filtered criteria on the internet; however, they don't appear to work for worksheets that contain data within an Excel table. I've tried everything and nothing seems to help. Here is my problem:
Imagine I have an Excel table with the following columns:
CustomerID (FILTERED BASED ON COLOR YELLOW) | Date | Category 1 (FILTERED) | SubCategory (FILTERED | Other |
<tbody>
</tbody>
The table can be filtered up to "x" number of columns, but for the purposes of this example let's assume 3 columns can be filtered (see above). These filters are not necessarily active at the same time.
The Function/Formula displaying the results of each filter would be entered into a different cell(s) somewhere on the sheet.
Any help is greatly appreciated!
TIA
Jay
Last edited: