G2 右拉 下拉{=OFFSET($A$1,RIGHT(SMALL(IF($C$2:$C$26-$B$2:$B$26+1>=COLUMN($A:$Z),MATCH($D$2:$D$26,$D$2:$D$26,)/1%+ROW($1:$25),9999),ROW(A1)),2),MATCH(G$1,$A$1:$E$1,)-1)&""
改H列{=IF(G2="","",RIGHT(SMALL(IF((D$2:D$26=G2)*(C$2:C$26-B$2:B$26+1>=COLUMN(A:M)),ROW($2:$26)*10^4+COLUMN(A:M)+B$2:B$26),COUNTIF(G$2:G2,G2)),4)-1)
留言
張貼留言