Filter function to link with Slicer

Copper Contributor

Hi All,

 

I have data table I have created 4-5 slicers related to different columns headers , now I want to show all the values list of a particular columns . For that I tried to use filter function but its giving me error can anybody tell me what is the issue in formula :- I am attaching sample file as well. Ple

=SORT(FILTER(Sheet1!$H$4:$H$27,(Sheet3!$A$4:$A$100=Sheet1!$B$4:$B$27)*(Sheet3!$C$4:$C$100=Sheet1!$C$4:$C$27)*(Sheet3!$E$4:$E$100=Sheet1!$D$4:$D$27)*(Sheet3!$G$4:$G$100=Sheet1!$E$4:$E$27),""),1,1)

 

1 Reply

@Rajender Singh 

That could be

=SORT(FILTER(Sheet1!$H$4:$H$27,
     COUNTIF(Sheet3!$A$4:$A$100,Sheet1!$B$4:$B$27)*
     COUNTIF(Sheet3!$C$4:$C$100,Sheet1!$C$4:$C$27)*
     COUNTIF(Sheet3!$E$4:$E$100,Sheet1!$D$4:$D$27)*
     COUNTIF(Sheet3!$G$4:$G$100,Sheet1!$E$4:$E$27),""),1,1)