G2:H12=LOOKUP(ROW(A1),SUBTOTAL(9,OFFSET($E$1,,,ROW($1:$6)))+1,A$2:A$69)&""
G2:H12另解{=INDEX(A:A,SMALL(IF($E$2:$E$6>=COLUMN($A:$Z),ROW($2:$6),9),ROW(A1)))&""
I2:J12=IF(G2="","",LEFT(VLOOKUP($G2*1,$A:$C,3,))&MID(VLOOKUP($G2*1,$A:$C,3,),2,9)+COUNTIF($G$2:$G2,$G2)-1)
留言
張貼留言