J5:K13{=INDEX(B:B,SMALL(IF(MATCH($B$2:$B$12&$C$2:$C$12&COUNTIFS($B$2:$B$12,$B$2:$B$12,$C$2:$C$12,$C$2:$C$12,$D$2:$D$12,$D$2:$D$12),$B$2:$B$12&$C$2:$C$12&COUNTIFS($B$2:$B$12,$B$2:$B$12,$C$2:$C$12,$C$2:$C$12,$D$2:$D$12,$D$2:$D$12),)=ROW($1:$11),ROW($2:$12),99),ROW(A1)))&""
L5:W13{=IFERROR(OFFSET($D$1,SMALL(IF(($B$2:$B$12&$C$2:$C$12=$J5&$K5)*($D$2:$D$12=LOOKUP("嫻",$L$3:L$3)),ROW($1:$11)),COUNTIFS($J$5:$J5,$J5,$K$5:$K5,$K5)),MOD(COLUMN(A1)-1,3)+1),"")
留言
張貼留言