返回列表 上一主題 發帖

請幫忙~~急 如何用EXCEL做16位編碼單號

A1=CONCATENATE("0002ab730",CHOOSE(INT((ROW(A402)-1)/16^2)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"),CHOOSE(MOD(INT((ROW($N402)-1)/16),16)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"),CHOOSE(MOD(ROW(A402)-1,16)+1,0,1,2,3,4,5,6,7,8,9,"A","B","C","D","E","F"))
向下複製
學海無涯_不恥下問

TOP

        靜思自在 : 能付出愛心就是福,能消除煩惱就是慧。
返回列表 上一主題