Forum Discussion
Hot to capture Slicer selected value from formula?
Hi Riny_van_Eekelen/ Lorenzo , I'm using Slicer with non-pivot table. I need to show my slicer selected item/items on another cell. Please provide me any workaround/solution for my problem. Than...
Krishnan1989 Perhaps the attached file does what you want. Note that I added a helper column to the table that will allow you to filter the table for only visible (i.e. selected) rows.
Hi Riny_van_Eekelen,
1st of all thank you for the reply and I'm using excel 2016 so I can't use the FILTER and UNIQUE function.
