[第131期]招生录取（已评分待总结）

佑卜子

今天冒昧的发个帖子，自己写了一段974个字符的函数公式，解决了本题。俺字符可是最多的，但是，咱思路还是独一无二的，我看了下大神们的代码，我只能说我还看不懂，还得慢慢学习。废话不多说了，上函数。

=IFERROR(INDEX($A$1:$A$23,SMALL(IF(IF(IF($B$2:$B$23>=560,1,IF($B$2:$B$23>=530,2,IF($B$2:$B$23>=517,3,IF($B$2:$B$23>=500,4,IF($B$2:$B$23>=460,5,6)))))<=IF($C$2:$C$23=$M$2,1,IF($C$2:$C$23=$M$3,2,IF($C$2:$C$23=$M$4,3,IF($C$2:$C$23=$M$5,4,5)))),IF($C$2:$C$23=$M$2,1,IF($C$2:$C$23=$M$3,2,IF($C$2:$C$23=$M$4,3,IF($C$2:$C$23=$M$5,4,5)))),IF(IF($B$2:$B$23>=560,1,IF($B$2:$B$23>=530,2,IF($B$2:$B$23>=517,3,IF($B$2:$B$23>=500,4,IF($B$2:$B$23>=460,5,6)))))<=IF($D$2:$D$23=$M$2,1,IF($D$2:$D$23=$M$3,2,IF($D$2:$D$23=$M$4,3,IF($D$2:$D$23=$M$5,4,5)))),IF($D$2:$D$23=$M$2,1,IF($D$2:$D$23=$M$3,2,IF($D$2:$D$23=$M$4,3,IF($D$2:$D$23=$M$5,4,5)))),IF(IF($B$2:$B$23>=560,1,IF($B$2:$B$23>=530,2,IF($B$2:$B$23>=517,3,IF($B$2:$B$23>=500,4,IF($B$2:$B$23>=460,5,6)))))<=IF($E$2:$E$23=$M$2,1,IF($E$2:$E$23=$M$3,2,IF($E$2:$E$23=$M$4,3,IF($E$2:$E$23=$M$5,4,5)))),IF($E$2:$E$23=$M$2,1,IF($E$2:$E$23=$M$3,2,IF($E$2:$E$23=$M$4,3,IF($E$2:$E$23=$M$5,4,5)))),6)))=COLUMN(A$1),ROW($B$2:$B$23),4^8),ROW(A1))),"")

yanglinzi

谢谢，正在学习

ggw092

开火车，新版本WPS

1. =VSTACK({"录取情况","录取人员明细"},LET(C,LET(B,SORT(DROP(REDUCE("",B3:B24,LAMBDA(X,Y,VSTACK(X,LET(A,OFFSET(Y,,2,,3),HSTACK(TAKE(FILTER(A,OFFSET(Y,,1)>XLOOKUP(A,$H$3:$H$7,$I$3:$I$7),""),,1),Y))))),1)),GROUPBY(TAKE(B,,1),TAKE(B,,-1),ARRAYTOTEXT,,0,)),HSTACK(VSTACK("未录取",DROP(TAKE(C,,1),1)),TAKE(C,,-1))))

复制代码