Skip to content

Instantly share code, notes, and snippets.

@nucreativa

nucreativa/excel-formulas.md

Created January 12, 2016 06:47
Show Gist options
  • Save nucreativa/fbc547b2ce8a566c63be to your computer and use it in GitHub Desktop.
Save nucreativa/fbc547b2ce8a566c63be to your computer and use it in GitHub Desktop.
Download ZIP
Excel Formulas
Raw
excel-formulas.md

To get last non-empty cell in a column

=OFFSET($A$1;COUNTA(A:A)-1;0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment