Grouping Slicers - excel

Rayne
Rayne used Ask the Experts™
on
Hey All,

please see attached. How do  create a grouping slicer?
groupSlicer.jpg
gruping-Slicers.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi,

First you need to convert normal range to Pivot Table, then please refer Grouping items in pivot table slicers

Once you created groups, then select the group name in Pivot and in Formula Bar, change Group1 to desired name

Please find attached...
gruping-Slicers.xlsx

Author

Commented:
thank you :)
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Pleased to help Rayne!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial