求助！

alanyao168

该发言已删除

huihuang6669

1. =REDUCE(C1:G1,B2:B55,LAMBDA(x,y,LET(bj,TOROW(FILTER(kr!A2:A18,BYROW(kr!C2:K18=y,OR)),1),wl,UNIQUE(FILTER(成绩!AC2:AC785,BYROW(成绩!C2:C785=bj,OR))),km,FILTER(kr!C1:K1,BYCOL(kr!C2:K18=y,OR)),cj,CHOOSECOLS(成绩!A2:AC785,MATCH(km,成绩!A1:AC1,)),zf,成绩!Z2:Z785,t,VSTACK(x,HSTACK(MAP(1-REGEXP(C1:E1,"\d+")/100,LAMBDA(a,ROWS(FILTER(cj,(cj>=PERCENTILE(FILTER(cj,cj<>""),a))*BYROW(成绩!C2:C785=bj,OR))))),LET(fs,DROP(REDUCE(0,wl,LAMBDA(d,a,VSTACK(d,FILTER(zf,(成绩!AC2:AC785=a)*BYROW(成绩!C2:C785=bj,OR)*(zf>=PERCENTILE(FILTER(zf,成绩!AC2:AC785=a),0.2)))))),1),HSTACK(ROWS(fs),AVERAGE(fs)/6)))),t)))

复制代码