In[]:=
ClearAll["Global`*"]
In[]:=
dat1={{"a","b","c","d"},{0.8506528467847064`,0.19386888003214497`,0.1504045496455485`,"e"},{0.7195862131245908`,0.017582176603254118`,0.5214125763555442`,"g"},{0.7263226336730568`,0.8698823542436853`,0.6602573542383826`,"h"},{0.6067068998308363`,0.023784367998135547`,0.023784367998135547`,"g"},{0.4958045202874567`,0.8122261047378432`,0.7254588690942614`,"j"},{0.7824761449995872`,0.6017654869901663`,0.8802097519836729`,"j"},{0.7969820972948404`,0.07259639212866675`,0.6200812082471042`,"g"},{0.0030296082244598566`,0.4730041202658529`,0.1434670120460252`,"k"},{0.0453768348228587`,0.8754466588301568`,0.9148551982077295`,"h"},{0.3394484976869624`,0.016104729247957472`,0.7538435849272475`,"k"},{0.2828884413756151`,0.39372834013060565`,0.4822262205502784`,"g"},{0.9985176923157191`,0.6258092181752531`,0.21283772566503778`,"g"},{0.5772799514478509`,0.9480582781076046`,0.3661099589442399`,"f"},{0.604284495537385`,0.665263930229487`,0.1455250032629396`,"j"},{0.08989454577308487`,0.7544735654906742`,0.6201027753742194`,"f"},{0.4586263374272106`,0.48278721709449923`,0.09649376801013398`,"k"},{0.6514954739030896`,0.39896244941613945`,0.020175284773849445`,"f"},{0.9696817418978328`,0.7808064658119253`,0.13587047946805786`,"g"},{0.9428573756213195`,0.600443825236481`,0.746683624607307`,"e"},{0.07504032245216696`,0.3147340436053614`,0.506036662242295`,"h"},{0.1337836163767956`,0.4811439391543081`,0.3213607932450022`,"f"},{0.8638175188541498`,0.2165947894053083`,0.40843764691685236`,"k"},{0.8466829456640058`,0.483085935104699`,0.09513826191895347`,"f"},{0.7828985191395651`,0.6417460557138793`,0.7712651900200709`,"g"},{0.21349112415274407`,0.9888948147519798`,0.3827922488762281`,"e"},{0.2491241098530087`,0.43976516982228475`,0.8880545550681043`,"h"},{0.6167403408163785`,0.36068909157643747`,0.277416955808628`,"g"},{0.2952488161465321`,0.27899292221908367`,0.5819544387635388`,"k"},{0.6189772745166416`,0.20236611584364905`,0.4269549201274031`,"j"},{0.046896959103089664`,0.4399503079788851`,0.5077881339699469`,"e"},{0.1058693660165615`,0.888454916791306`,0.36166131765667664`,"g"},{0.5891624675270593`,0.5755048803023511`,0.9255740530596851`,"g"}};
In[]:=
xlsx2Dataset[fn_,rowHead_,colHead_]:=Module[{dat,dimr,dimc,cHead,rHead,af},dat=fn;​​{dimr,dimc}=Dimensions[dat];​​If[rowHead1&&colHead1,​​cHead=dat[[1,2;;dimc]];​​rHead=dat[[2;;dimr,1]];​​af=AssociationThread[rHead,Map[AssociationThread[cHead,#]&,dat[[2;;dimr,2;;dimc]]]]]|​​If[rowHead1&&colHead0,​​​​rHead=dat[[1;;dimr,1]];​​af=AssociationThread[rHead,dat[[1;;dimr,2;;dimc]]]]|​​If[rowHead0&&colHead1,​​cHead=dat[[1]];​​af=Map[AssociationThread[cHead,#]&,dat[[2;;dimr]]]]|​​If[rowHead0&&colHead0,af=dat];​​Dataset[af]​​]
In[]:=
tabl=xlsx2Dataset[dat1,0,1];
In[]:=
myfun[ro_,col_,ls_,hs_]:=tabl[Select[MemberQ[ro,#d]&&ls≤If[MatchQ[col,"a"],#a,If[MatchQ[col,"b"],#b,#c]]≤hs&]]
In[]:=
Manipulate[Apply[myfun,{x,tc,lv,hv}],{tc,{"a","b","c"}},{x,{"e","f","g","h"},ControlTypeCheckboxBar},{lv,0,1},{hv,0,1}]
Out[]=
​
tc
a
b
c
x
e
f
g
h
lv
hv
myfun[{f,g},b,0,0.68]