I3:I10{=INDEX(A:A,SMALL(IF(A$3:A$23<>"",ROW($3:$23),99),SMALL(IF(MMULT(TRANSPOSE(ROW(1:21)^0),N(COUNTIF(OFFSET(A$3,,,ROW($1:$21)),"<>")={1,2,3,4}))/3>=ROW($1:$9),{1,2,3,4},9),ROW(A1))))&""
J3:L10=IF($I3="","",OFFSET($B$2,MATCH($I3,$A:$A,)-3+COUNTIF($I$3:$I3,$I3)+COUNTIF($I:$I,$I3)*(COLUMN(A1)-1),))
留言
張貼留言