Filter function to link with Slicer

%3CLINGO-SUB%20id%3D%22lingo-sub-2187711%22%20slang%3D%22en-US%22%3EFilter%20function%20to%20link%20with%20Slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187711%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20data%20table%20I%20have%20created%204-5%20slicers%20related%20to%20different%20columns%20headers%20%2C%20now%20I%20want%20to%20show%20all%20the%20values%20list%20of%20a%20particular%20columns%20.%20For%20that%20I%20tried%20to%20use%20filter%20function%20but%20its%20giving%20me%20error%20can%20anybody%20tell%20me%20what%20is%20the%20issue%20in%20formula%20%3A-%20I%20am%20attaching%20sample%20file%20as%20well.%20Ple%3C%2FP%3E%3CP%3E%3DSORT(FILTER(Sheet1!%24H%244%3A%24H%2427%2C(Sheet3!%24A%244%3A%24A%24100%3DSheet1!%24B%244%3A%24B%2427)*(Sheet3!%24C%244%3A%24C%24100%3DSheet1!%24C%244%3A%24C%2427)*(Sheet3!%24E%244%3A%24E%24100%3DSheet1!%24D%244%3A%24D%2427)*(Sheet3!%24G%244%3A%24G%24100%3DSheet1!%24E%244%3A%24E%2427)%2C%22%22)%2C1%2C1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2187711%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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)