區間以 ID為藉 彙整上下二格 (12077)

D2=IF((COLUMN(A1)>INT((MATCH(1=1,$A3:$A19="",)-1)/2))+($A2<>"ID"),"",IF(COLUMN(A1)=1,"","+")&INDEX($B3:$B19&"("&$B4:$B20&")",COLUMN(A1)*2-1)&E2)