退票编号 放後面 (10599)

E2 下拉=INDEX(B:B,SMALL(IF(B$2:B$99="",99,ROW($2:$99)),ROW(A1)))&""

F2 下拉 {=IF(E2="","",IF(C2="",MAX(F$1:F1)+1,INDEX(C:C,100-RIGHT(LARGE(IF(MMULT(N(B$2:C$99<>""),{1;1}),MMULT(N(B$2:C$99<>""),{1;1})/1%-ROW($2:$99)),ROW(B1)),2))))