选中B14,定义名称:aa=INDEX($A:$A,LOOKUP(INT((ROW()-9)/5),{1;2;3},SMALL(IF(MATCH($A$2:$A$9,$A$2:$A$9,)=ROW($1:$8),ROW($1:$8),999),ROW(INDIRECT("1:"&SUM(1/COUNTIF($A$2:$A$9,$A$2:$A$9)))))+1)) 然后输入公式三键数组公式:下拉 =IF(MOD(ROW()+1,5),INDEX(C:C,SMALL(IF((aa=A$2:A$9)*(COUNTIF(OFFSET($B$13,5*INT((ROW()-15)/5),,MOD(ROW()+1,5)+1),C$2:C$9)=0),ROW($1:$8),999),1)+1),"")&""
Kp4lW35K.rar
(5.64 KB, 下载次数: 119)
|