F2:F5=COUNTA(INDIRECT(G2&"!A:A"))-1
A2:A16=LOOKUP(ROW()-2,SUBTOTAL(9,OFFSET($F$1,,,ROW($1:$5))),G$2:G$6)&""
B2:C16=IF($A2="","",INDIRECT($A2&"!"&CHAR(65+(B$1=$C$1))&1+COUNTIF($A$1:$A2,$A2)))
方式二
F1=0
F2:F5=COUNTA(INDIRECT(G2&"!A:A"))+F1-1
A2:A16=IF(ROW()-1>MAX(F:F),"",INDEX(G:G,MATCH(ROW()-2,F:F)+1))
留言
張貼留言