List Slicer Selections in a Cell in Excel

[@makisalimhussain2334]

Thank you Jon New Trick idea I tried another way without using helper sheet and succeeded; following steps below: 1- Go to Pivot Table 2- Go to Design tab - Report Layout - Show in Outline Form 3- Write TEXTJOIN formula and select one group of Categories column of the Pivot Table And that's it. The formula will work according the slicer selection. Thanks Maki S. Hussain Baghdad-Iraq

[@anacdom]

I've been searching for a solution like this for 2 days and I was going crazyyyy. I thought I could only do that using VBA or something. Thank you sooo much. This trick is awesome!

[@sramandcotrivandrum423]

That was amazing! Thanks from India!

[@AmySwayzee]

Great trick. Didn't know textjoin. Will use this immediately!

[@TeachExcel]

If you have a newer version of Excel, it is a must-use! I'm glad you like the trick :)

[@plavali_znaem]

was looking exactly for this!!

[@HuIk7]

Man you saved my life. Thank you !

[@kellybrehm911]

I love this. Now I want to take this and 'link' the cell to a text box but I'm running into a problem. Not all the text translates into the text box from the cell, only some of it does. Can you help?

[@rahularanger407]

Nice, I was wondering if we could do opposite, like here we can selected Multiple Items like Bathing, Gardening to store "Bathing, Gardening". is it Possible to select Bathing from a cell that contains "Bathing, Gardening."

[@KilianDarkwater]

Neat trick and captivating voice! Even enchanting ;-)

[@marekzadecki470]

It's very interesting. Thank you Don! Great trick.

[@TeachExcel]

Thanks for the comment Marek! I'm glad you like it :)

[@IvanCortinas_ES]

Supertrick! Thank you Don!

[@TeachExcel]

Thanks a lot Ivan!! I'm glad you like it :)

[@GeertDelmulle]

If you add the table to the data model, then you can add small and simple DAX measure to CONCATENATEX those VALUES and then show that measure in a single cell pivot table, right here. No need for a helper sheet.

[@wayneedmondson1065]

Great trick! Thanks for sharing :)) Thumbs up!!

[@TeachExcel]

Thanks Wayne!! I'm glad you think so :))

[@darrylmorgan]

Really Neat Little Trick/Tip...Thank You Sir :)

[@TeachExcel]

Thanks Darryl!! I'm glad you like this trick :))

[@abidfarid439]

Wonderful trick. thank you.

[@garethmorrall1047]

Is it possible for the cell to return nothing or “ALL” if no slicer option is selected? Say if slicer is “Customer” with 100 unique customers but only want the cell to return selected customers not all 100 customers listed when the slicer isn’t selected/filtered. Iw this possible? Thanks

[@rajeshchawda9449]

what if I do not have the latest version of Excel with TEXTJOIN? How can we achieve the same functionality without TEXTJOIN (I mean with some other older version functions)?

[@TeachExcel]

Here is another tutorial I made that will help you combine values in older versions of Excel: www.teachexcel.com/free-excel-macros/2201/simple-excel-function-to-combine-values-in-all-versions-of-excel-udf?nav=yt_comment

[@JoRands1]

@@TeachExcel Hi, I tried your other method as I am using Excel 2016 Pro which does not have TextJoin. The UDF works as intended, but when I use it with the slicer as in the video method. The text does not update automatically, it just lists all of the words together. IS this how it should be or did i do something wrong? Update: Tried this same method on the online version with TEXTJOIN and seeing the same problem. The slicer is moving correctly and the text is joining but its not being updated with the slicer.

[@MarioLopez-eu8tj]

How can i select one element of the slicer from a cell value ?

[@millanchauhan]

This is fantastic! Thanks so much!

[@karimallahwala7022]

Very helpful thank you very much

[@HamzaAshur]

Thanks a lot u helped finish my idea perfectly

[@jimfitch]

Very clever!

[@TeachExcel]

Thank You :)))

[@vikaasb2016]

Super helpful

[@TeachExcel]

Thanks Vikus! I'm glad you think so :))

[@raorahul358]

Thanks it was very useful 👍

[@COURSSTATSCHAMBERY]

nice tip Tks

[@paulaparo1583]

The trick is useful. I thank you for that. Rest assured that viewers will understand what you're saying even if you speak normally.

[@abbottkatz2535]

Not only can you hide the Raw sheet you can delete it, as the pivot table draws its data from a hidden cached replica of Raw.

[@TeachExcel]

Pivot Cache is really great, you just won't be able to update the values easily then. But I like your idea for streamlining a workbook with static data!!!

[@abbottkatz8830]

@@TeachExcel Thanks. True - the only way I know how to update values would be to double-click a grand total in a pivot table, which restores the data source.

[@Excelambda]

Perfection!!!😊✌

[@ajayv304]

Amazing

[@Rice0987]

Today is 444th day of terrorusia's war against us... and i have put my 444th like to this nice tip. Thanks!

[@Flameville]

Everything about excel is needlessly confusing it’s annoying can’t wait for A.I to do this for me

[@AXNJXN1]

You're 'file' isn't sanitized, rather all the points you've created (in this vid) are actually already setup IN the downloadable file so you can't really 'follow along'... You may want to sanitize it then upload so it truly can be edited alongside your video. Additionally, your point of view(s) seem to be all over the place for this tut., politely stating this... What exactly are you trying to teach? That it's flexible or saving time with something?

[@TeachExcel]

I am only trying to teach you what is in the title of the video - if this is a trick that you would like to use, then you now know how to use it and if not, then you only lost a few minutes of time. For the file that you can download, you are right in saying that I do not provide a "Before" and "After" file and I do not plan to do so - if you want to start from scratch, then create a new file or delete the final data from the downloadable file. I feel that what I provide allows you to follow along at whatever pace you would like, and deleting existing data from the downloadable file takes mere seconds.