Skip to content

Instantly share code, notes, and snippets.

@zkarpinski

zkarpinski/Excel_Formulas.md

Last active August 29, 2015 13:57
Show Gist options
  • Save zkarpinski/9735254 to your computer and use it in GitHub Desktop.
Save zkarpinski/9735254 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Formulas and Specific VBA Scripts
Raw
Excel_Formulas.md

Excel Formulas that are useful

Query with outside variable

This forumla runs a query where the contains data, is using outside sources from a specific cell concatenated with a string.

=Query(Markets!2:151,"select B where A contains'" & Concatenate (Portfolio!B4, "/BTC") &"' ")
Raw
Excel_Tricks.md

Excel Tricks

Last row in column

This forumla uses a trick to get the last row in the column.

=(INDEX(A1:A; COUNT(A1:A))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment