循環遞增 0~指定數環遞增 (12935)

 B2下拉=IF(MOD(NOW(),1)>B$2, TEXT(MOD(SECOND(NOW())*B$6+ROW(A1),B$6+1),"000"),"X")



留言