Hi all,



I would need to view the slicer selection into a cell. I saw many resources on the web, but all of them where dealing with Pivot Table.

I am not using Pivot Table in this case.

Could you support me.

Many thanks in advance

Just to be sure, have you corss-posted anywhere like in your last thread? If so please add links. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

See How To Insert Slicer In Excel Without Pivot Table | Sourcetable

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hello

I did not ask the same question in another Forum.

I learned now

Hello Pecoflyer

thanks for your inputs, however I was not able to find the right answer. Could you please clarify this?

Thanks.

Your question being a little vague perhaps under the title "Inserting a Slicer in Excel Without a Pivot Table"?
If this is not what you want, please clarify your requirements. Thx


(BTW cross posting is not forbidden anywhere, you just need to add links to your cross posts. I gather you read why on excelguru.ca?)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

You are right, I could specify the target much better.

What I want to do is to have the value of what I selected in a Slicer viewed in a cell, changing after slicer selection change.

I do hope I was clearer now.

Many thanks

Not straightforward. I'm sure there's a convoluted solution using cube functions and the data model, but before I explore that (I've never done it before) there may be a simpler solution that might do for you.
Its fault is that it shows not just the slicer selection of just one column of your table but the resulting unique values in one column of all the filters that may have been applied to any columns of that table.
Spilling list:
One cell list, same but:
See attached.


ps. shorter versions of those formulae:

Attached Files

msofficeforums52403.xlsx (17.5 KB, 0 views)

IT WORKS!!.

Many thanks