[已解决]20221205求助

流住你

要求：在e5：g19中，在h5到h19中，有对，其间也有错的在中间，想将对的结果放在前面，然后到错的结果排在后面放到h21到h35中，

最佳答案

月排行榜 / 总排行榜

hugeinfo

2022-12-5 20:33

=INDEX(D:D,RIGHT(SMALL(IF($H$5:$H$19={"对","错"},ROW($5:$19)+COLUMN($A:$B)*100),ROW(A1)),2))

跳转到最佳答案楼层

hugeinfo

=INDEX(D:D,RIGHT(SMALL(IF($H$5:$H$19={"对","错"},ROW($5:$19)+COLUMN($A:$B)*100),ROW(A1)),2))

hcm19522

F2:H17{=INDEX(B:B,RIGHT(SMALL(IF($D$2:$D$17<>"",($D$2:$D$17="错")/1%+ROW($2:$17),9999),ROW(A1)),2))&""

J2:L17{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($D$2:$D$17<>"",IF($D$2:$D$17="对",1,100-ROW($2:$17))/1%+ROW($2:$17)),ROW(A1)),2)),"")

hcm19522

F2:H17{=INDEX(B:B,RIGHT(SMALL(IF($D$2:$D$17<>"",($D$2:$D$17="错")/1%+ROW($2:$17),9999),ROW(A1)),2))&""

J2:L17{=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($D$2:$D$17<>"",IF($D$2:$D$17="对",1,100-ROW($2:$17))/1%+ROW($2:$17)),ROW(A1)),2)),"")

流住你

多谢两位老师