Skip to content

Instantly share code, notes, and snippets.

@supernoveau

supernoveau/excel.md

Created April 5, 2017 18:12
Show Gist options
  • Save supernoveau/72ec94ec2255d7a8eef918bedb29a396 to your computer and use it in GitHub Desktop.
Save supernoveau/72ec94ec2255d7a8eef918bedb29a396 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
excel.md

Excel

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment