Catching Multiple Slicer Selections in a Formula
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.
Read more...Tags: slicer