Excel - How to Display Selected Slicer Value(s) in a Cell
A Slicer is used to apply a filter to a Pivot Table. It consists of a set of clickable buttons. But what if you want to display the text from the selected button or buttons and display it in a single cell?
This question has been asked several times recently in my Pivot Tables classes. In this video I show you my solution.
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:01:14 Create a Pivot Table
00:01:53 Connect Pivot Table to the Slicer
00:03:03 Display Selected Item (Single) from the Slicer
00:04:14 Display all the Selected Items from the Slicer
🗒 Notes and Resources
Download a copy of the file used in this video: https://p148.p4.n0.cdn.getcloudapp.co...
The formulas that I used in the demos:
=Pivots!M3
=TEXTJOIN(", ",TRUE,M3:M20)
=Pivots!N2
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #slicer #pivottable