身分證號碼 隨機產生 (13448)

F2=INDEX(C:C,RANDBETWEEN(2,23))&RANDBETWEEN(1,2)&RANDBETWEEN(10^6,10^7-1)

G2=F2&MOD(10-SUMPRODUCT(MID(VLOOKUP(LEFT(F2),C:D,2,)&MID(F2,2,9),ROW($1:$10),1)*MID(1987654321,ROW($1:$10),1)),10)