Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =COUNTA(INDIRECT("F18"&":F"&ROW()))
- =MOD(COUNTA(INDIRECT("F18"&":F"&ROW())),3)
- =MOD(COUNTA(INDIRECT("F18"&":F"&ROW())),3)
- =MOD(ROW(C18)-ROW($C$18),3)+1
- =MOD(INT((ROW(B18)-ROW($B$18))/3),3)+1
- =MOD(INT((ROW(A18)-ROW($A$18))/9),3)+1
- =A18&"."&B18&"."&C18
- =MOD(INT((ROW(A18)-ROW($A$18))/9),3)+1&"."&MOD(INT((ROW(B18)-ROW($B$18))/3),3)+1&"."&MOD(ROW(C18)-ROW($C$18),3)+1
Add Comment
Please, Sign In to add comment