票據起止號 分別取出 (14911)

F3{=IF(MAX(G$2:G2)=MAX(B:B),"",MIN(IF(B$2:B$99>N(G2),B$2:B$99)))

G3{=IF(F3="","",MATCH(,COUNTIF(B:B,F3+ROW($1:$99)),)+F3-1)

H3 =IF(F3="","",SUMIFS(C:C,B:B,">="&F3,B:B,"<="&G3))

F3另解 =IF(MAX(G$2:G2)=MAX(B:B),"",LOOKUP(,0/FREQUENCY(N(G2)+1,B$2:B$99),B$2:B$3))

G3另解 =IF(F3="","",LOOKUP(,0/FREQUENCY(0,COUNTIF(B:B,F3+ROW($1:$99))),F3+ROW($1:$99)-1))