L2:P2 下拉{=INDEX(B:B,SMALL(IF(MMULT(COUNTIF($H:$H,$B$2:$F$16),Z1:Z5+1)>=$J$2,ROW($2:$16),99),ROW(A1)))&""
B2:F16格式化=SUMPRODUCT(N(COUNTIF($H:$H,$B2:$F2)>0))>=$J$2
R2:V2 下拉{=INDEX(B:B,SMALL(IF(MMULT(COUNTIF($H:$H,$B$2:$F$16)/COUNTIF(OFFSET($B$1:$F$1,ROW($1:$15),),$B$2:$F$16),Z1:Z5+1)>=$J$2,ROW($2:$16),99),ROW(A1)))&""
留言
張貼留言