I2:K21{=INDEX(B:B,SMALL(IF(VLOOKUP(T(IF({1},LOOKUP(ROW($2:$21),ROW($2:$21)/($A$2:$A$21<>""),$A$2:$A$21))),$F:$G,2,)="V",ROW($2:$21),99),ROW(A1)))&""
另解{=INDEX(B:B,SMALL(IF(1-ISNA(MATCH(LOOKUP(ROW($2:$21),ROW($2:$21)/($A$2:$A$21<>""),$A$2:$A$21)&"V",$F$2:$F$6&$G$2:$G$6,)),ROW($2:$21),99),ROW(A1)))&""
留言
張貼留言