二A字頭區間非空數 (9572)

輔助 C1:C25 {=IF(LEFT(B1)="A",MAX(SUM(N(OFFSET(B2,,,-LOOKUP(,-MATCH(1=1,LEFT(B2:B$26)="A",{1,0}))-1)<>"")),1),"")

F2:F11 {=IFERROR(OFFSET(B$1,SMALL(IF((0&C$1:C$25)*1>=COLUMN(A:I),ROW($1:$25)-1),ROW(A1)),),"")