Forum Discussion
TARABZTK
Oct 10, 2022Tin Contributor
How to capture the selected value of a slicer in a formula?
I need to capture the selected value of a slicer like ID or Date. In browsing the Slicer Settings, there a defined name for the Slicer and stated that its can be used in a formula. I tried to in inse...
Riny_van_Eekelen
Oct 10, 2022Platinum Contributor
TARABZTK The attached article clearly demonstrates how to do just that. And at the end it also explains the real meaning of the bit "Name to use in formulas:"
https://www.myonlinetraininghub.com/use-excel-slicer-selection-in-formulas