Forum Discussion
Slicers
I just want to make sure that you're aware not only of slicers but also of the recently introduced FILTER and other "Dynamic Array" functions.
From your description of what you're trying to do, I think it's entirely possible that you'd be able to accomplish it with FILTER. It allows you to use criteria from multiple columns as the basis for the filtering it does..... And you can do it on a separate sheet in the same workbook quite easily (thus creating a form of Dashboard, extracting data from the larger table based on current need).
Is the spreadsheet you have one you can share or does it contain lots of confidential info (if the latter, then it should be rendered anonymous before sharing)?
Here's a link to a YouTube video that explains and demonstrates the dynamic array functions, if you'd like to just pursue it on your own. https://www.youtube.com/watch?v=9I9DtFOVPIg
mathetes Two screen shots attached. One is what is happening. Second is what I would like to happen.
And an hour before you posted this you said you were going to try out the FILTER function. What happened with it? It is new, to be sure, and only on the most recent releases of Excel, so you may not have been able to get it to work if you're using an older Excel. But the feedback would be helpful.
I still think it might do what you're wanting to do, and be less mysterious, since you'd be in control.
mathetes I am experimenting with the filter function right now.
DaleWilson what i believe is happening is that excel just doesn't have any more cell rows 'defined'. You could try to 'add' rows to excel to make sure you always have additional blank rows so the slicer is clipped (you should be able to scroll to a spot outside the table and add some spaces or something or maybe someone else will chime in with a 'better' way). OR you could just move your table down and put the slicer(s) ABOVE the table. Even 1 row and you can adjust the height of row 1 to fit the size of your slicer(s). Then if you 'freeze' the top of the table the slicer will also be 'frozen' in view.
Perhaps you may share a sample file instead of screenshot to check how your table is organized.
