Data Filter

[Imranmanasiya]

Hello all,

I have a worksheet (Named ad FTR Details) which has a data for 33 columns and more than 1000 Rows. I need to filter the data on the basis of Month and the Team member. Criteria is based on a different sheet called as DASHBOARD. In Cell D2, I have a drop down where in I select the name and Cell H2 has a month where I select the month and the data should get filtered based on the Criteria D2 and H2. Also if I make both the criteria cells (i.e. D2 and H2 on Sheet "DASHBOARD") blank, if should remove all the filter from my worksheet (FTR Details)

Imran

 

[FranzV]

Have you tried using a Pivot Table or inserting a Slicer?

 

[Amanda Wilso]

In the PivotTable, click the arrow

on[FONT=wf_segoe-ui_semibold] Row Labels[/FONT] or [FONT=wf_segoe-ui_semibold]Column Labels[/FONT].
In the list of row or column labels, uncheck the [FONT=wf_segoe-ui_semibold](Select All)[/FONT] box at the top of the list, and then check the boxes of the items you want to show in your PivotTable
Click [FONT=wf_segoe-ui_semibold]OK.[/FONT]
The filtering arrow changes to this icon

to indicate that a filter is applied. Click it to change or clear the filter by clicking [FONT=wf_segoe-ui_semibold]Clear Filter From <Field Name>.[/FONT]