e4=IFERROR(INDEX(SORTBY(FILTER(OFFSET($B$4:$B$15,,MOD(COLUMN(A1),3)),ISNUMBER(FIND($C$4:$C$15,TEXT(COLUMN(A1),"[>3]!对错;对")))),SUBSTITUTE(SUBSTITUTE(FILTER($C$4:$C$15,ISNUMBER(FIND($C$4:$C$15,TEXT(COLUMN(A1),"[>3]!对错;对")))),"对","1"),"错","2")*1,1,FILTER($D$4:$D$15,ISNUMBER(FIND($C$4:$C$15,TEXT(COLUMN(A1),"[>3]!对错;对")))),-1),ROW(A1)),"") 下拉 右拉