Hi -
I'm building a template for inventory analysis. I currently have a file with columns A-CO (93 columns) and the rows will be up to 40,000 depending on the user needs.
I'm trying to create a list of filtered columns so the user can easily see which fields are filtered (rather than scrolling through the 93 columns to find them).
What I've tried:
Pivot tables and slicers are nice, but do not work well with a large number of columns.
I googled the question and reviewed many sites/blogs but I did not find a solution.
Any help is appreciated!
Thanks,
Tyler
I'm building a template for inventory analysis. I currently have a file with columns A-CO (93 columns) and the rows will be up to 40,000 depending on the user needs.
Filters are available on every column. In most cases only a handful of columns (1-10) will be filtered at a time.
I'm trying to create a list of filtered columns so the user can easily see which fields are filtered (rather than scrolling through the 93 columns to find them).
What I've tried:
Pivot tables and slicers are nice, but do not work well with a large number of columns.
I googled the question and reviewed many sites/blogs but I did not find a solution.
Any help is appreciated!
Thanks,
Tyler