Help in Excel Slicer

[jawaharprm]

Hi,

Pls help on this.
i have a slicer with months and other sheet i have date's, if i select jan month in sheet4 only jan date should be listed, if Feb only feb date should be listed Pls help on this.
Sample file enclosed for your reference.

Jawahar

 

[srinidhi]

You need to insert a pivot table and then the slicer for it. Please post the full data to help you out.

 

[GraH - Guido]

See attached, that's one way. I hope you see the dynamic array formulas to generate the dates.

 

[srinidhi]

Hope this helps