Mar 05 2021 03:19 AM
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)
Mar 05 2021 12:46 PM
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)