箱號起訖號 自動逐一顯示 (12531)

F2下拉=IF(ROW(A1)>-LOOKUP(1,-RIGHT(LOOKUP(1,0/(B$2:B6<>""),B$2:B6),{1,2,3})),"",ROW(A1))

G2:H2 下拉=IF($F2="","",OFFSET(C$1,LOOKUP($F2,LEFT($B$2:$B6,FIND("-",$B$2:$B6&"-"&$B$2:$B6)-1)*1,ROW($1:5)),))