Catching Multiple Slicer Selections in a Formula
User Rating: / 0
Written by Rob Collie   
Thursday, 08 September 2011 21:39

A long time ago I did a post on using slicer selections in Excel formulas. That technique only worked when you select single values on slicers, though - any more than one and the dreaded "(Multiple items)" foils your well-laid plans.

How to handle that multi-select case became a very common question - in email and posted as comments.


  Tags: slicer