#1
|
|||
|
|||
SLICER Selection into a cell
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 |
#2
|
||||
|
||||
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 |
#3
|
||||
|
||||
__________________
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 |
#4
|
|||
|
|||
Hello
I did not ask the same question in another Forum. I learned now |
#5
|
|||
|
|||
Hello Pecoflyer
thanks for your inputs, however I was not able to find the right answer. Could you please clarify this? Thanks. |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
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 |
#8
|
||||
|
||||
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: Code:
=UNIQUE(FILTER(Table1[Hdr1],SUBTOTAL(103,OFFSET(Table1[Hdr1],ROW(Table1[Hdr1])-MIN(ROW(Table1[Hdr1])),0,1)))) Code:
=TEXTJOIN(", ",FALSE,UNIQUE(FILTER(Table1[Hdr1],SUBTOTAL(103,OFFSET(Table1[Hdr1],ROW(Table1[Hdr1])-MIN(ROW(Table1[Hdr1])),0,1))))) ps. shorter versions of those formulae: Code:
=LET(a,Table1[Hdr1],UNIQUE(FILTER(a,SUBTOTAL(103,OFFSET(a,ROW(a)-MIN(ROW(a)),0,1))))) =LET(a,Table1[Hdr1],TEXTJOIN(", ",FALSE,UNIQUE(FILTER(a,SUBTOTAL(103,OFFSET(a,ROW(a)-MIN(ROW(a)),0,1)))))) |
#9
|
|||
|
|||
IT WORKS!!.
Many thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to move a selection one cell up using VBA? | Bumba | Excel Programming | 6 | 11-19-2019 08:50 AM |
How to trigger a macro on cell *selection* | Larry_1 | Excel Programming | 6 | 12-24-2017 11:09 AM |
Limit min and max number to a cell based on country selection | hussainshaikh1 | Excel | 1 | 02-02-2017 07:06 AM |
Selection from cell with list contents autopopulates contents of another cell | markharper80 | Excel | 3 | 02-16-2015 04:18 PM |
ms office excel 2007 cell selection issues | pavamaklava | Excel | 1 | 05-12-2010 10:47 PM |