Number every nth cell:
=MOD(ROW(),n) where n is a number
Fill down / right:
CTRL + D
CTRL + R
Show unique entries only:
=UNIQUE(A:B)
Created
April 5, 2017 18:12
-
-
Save supernoveau/72ec94ec2255d7a8eef918bedb29a396 to your computer and use it in GitHub Desktop.