L2:R31{=INDEX($B:$B,SMALL(IF((MATCH($B$2:$B$31,$B:$B,)=ROW($2:$31))*(COUNTIF($B:$B,$B$2:$B$31)+$K$1>=COLUMN($A:$Z)),ROW($2:$31),99),ROW(A1)*7-7+COLUMN(A1)))&""
另解{=INDEX($B:$B,SMALL(IF(($B$1:$B$30<>$B$2:$B$31)*(COUNTIF($B:$B,$B$2:$B$31)+$K$1>=COLUMN($A:$Z)),ROW($2:$31),99),ROW(A1)*7-7+COLUMN(A1)))&""
另解{=INDEX($B:$B,SMALL(IF((COUNTIF(OFFSET($B$2,,,ROW($1:$30)),$B$2:$B$31)=1)*$K$1+2>COLUMN($A:$Z),ROW($2:$31),99),ROW(A1)*7-7+COLUMN(A1)))&""
留言
張貼留言