要求:在g列g3:g16,要按照从大到小的去排列的才是对的结果,请老师在d列的函数=INDEX(C:C,RIGHT(SMALL(IF(B$3:B$16="对",ROW(B$3:B$16),ROW(B$3:B$16)+100),ROW(A1)),2)),修改一下,放到g列,结果如g3:g20,多谢! |
D3=INDEX(SORTBY(OFFSET($C$3:$C$16,,-(COLUMN(A1)-1)),SUBSTITUTE(SUBSTITUTE($B$3:$B$16,"对",1),"错",2)*1,1,$C$3:$C$16,-1),ROW(A1)) 右拉 下拉
|