How to get slicer selected values in excel 2016 cells

[Anonymous]

I have created a slicer in Excel 2016. I want to display selected slicer values in excel 2016.

How to do it ??

[v-yulgu-msft]

Hi @Anonymous,

To get the selected items from a slicer in Excel, please refer to below links:

Use Excel Slicer Selection in Formulas

Another way to get and use slicer values in formulas

Get selected items in a slicer in Excel 2016

By the way, since this the forum that supports Power BI, it looks like your question is more related to Excel, I would suggest you post threads on corresponding forum to get more professional advice if you still have any concern.

Regards,

Yuliana Gu