Home

Table Slicer Value in Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-834017%22%20slang%3D%22en-US%22%3ETable%20Slicer%20Value%20in%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834017%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20been%20dabling%20with%20Excel%20table%20slicers.%20When%20I%20chec%20the%20slicer%20settings%20there%20is%20a%20%22Name%20to%20use%20in%20formula%3A%22%20info%20which%20implies%20I%20can%20use%20the%20slicer%20selected%20value%20in%20a%20formula.%20However%20although%20I%20check%20the%20internet%20for%20this%20I%20couldn't%20find%20any%20information%20except%20for%20the%20slicers%20for%20pivot%20tables.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20would%20really%20like%20to%20learn%20whether%20I%20can%20use%20a%20table%20slicer%20selected%20value%20in%20a%20formula%20or%20in%20a%20cell%20range%3F%20If%20so%20how%20can%20I%20achieve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20support.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-840223%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20Slicer%20Value%20in%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-840223%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F232473%22%20target%3D%22_blank%22%3E%40erol%20sinan%20zorlu%3C%2FA%3E%26nbsp%3BThis%20name%20is%20for%20use%20in%20Power%20Pivot%20data%20models%20and%20using%20the%20CubeRankedMembers%20function%2C%20or%20using%20VBA.%20The%20slicer%20and%20its%20selection%20cannot%20be%20used%20in%20worksheet%20formulas.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20you%20can%20use%20the%20slicer%20selection%20in%20formulas%20with%20a%20few%20tricks.%20Check%20out%20this%20article%20by%20Excel%20MVP%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F133371%22%20target%3D%22_blank%22%3E%40Mynda%20Treacy%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Fuse-excel-slicer-selection-in-formulas%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myonlinetraininghub.com%2Fuse-excel-slicer-selection-in-formulas%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-840240%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20Slicer%20Value%20in%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-840240%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20the%20reply.%20I%20already%20know%20about%20this%20solution%20however%20I%20think%20it%20would%20be%20good%20to%20implement%20this%20functionality%20as%20adding%20a%20pivot%20table%20also%20has%20its%20flaws%20such%20as%20need%20to%20refresh%20if%20any%20new%20data%20is%20added.%3C%2FP%3E%3C%2FLINGO-BODY%3E
erol sinan zorlu
Regular Contributor

Hello,

I have been dabling with Excel table slicers. When I chec the slicer settings there is a "Name to use in formula:" info which implies I can use the slicer selected value in a formula. However although I check the internet for this I couldn't find any information except for the slicers for pivot tables.  

 

So I would really like to learn whether I can use a table slicer selected value in a formula or in a cell range? If so how can I achieve this?

 

Thanks in advance for any support.

2 Replies

@erol sinan zorlu This name is for use in Power Pivot data models and using the CubeRankedMembers function, or using VBA. The slicer and its selection cannot be used in worksheet formulas.

 

But you can use the slicer selection in formulas with a few tricks. Check out this article by Excel MVP @Mynda Treacy https://www.myonlinetraininghub.com/use-excel-slicer-selection-in-formulas

 

@Ingeborg Hawighorst 

thanks for the reply. I already know about this solution however I think it would be good to implement this functionality as adding a pivot table also has its flaws such as need to refresh if any new data is added.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies