随机產生各區域桩号 (10557)

C2:D4{=-LOOKUP(9,-MID($B2,SMALL(IF(MID($B2,ROW($1:$98),1)="+",ROW($2:$99)),COLUMN(A1)),ROW($1:$9)))

F2:F4=COUNT(G2:K2)

M2:Q4 區域數組 {=IFERROR(RIGHT(SMALL(RANDBETWEEN(ROW(INDIRECT("1:"&F2))^0,999)*10^8+RANDBETWEEN((D2-C2)/$F2*(ROW(INDIRECT("1:"&F2))-1)+C2+5,(D2-C2)/$F2*ROW(INDIRECT("1:"&F2))+C2-5),COLUMN(A:E)),8)*1,"")