F2:G12{=INDEX(B:B,RIGHT(SMALL(IF(COUNTIF(OFFSET($B$2,,,ROW($1:$18)),$B$2:$B$19)-1<COUNTIF($B:$B,$B$2:$B$19)/2,$B$2:$B$19/1%+ROW($2:$19),999),ROW(A1)),2))&""
I2:J12{=INDEX(B:B,RIGHT(SMALL(IF(COUNTIF($G:$G,$C$2:$C$19),999,$B$2:$B$19/1%+ROW($2:$19)),ROW(A1)),2))&""
留言
張貼留言