Skip to Content

Spreadsheet tricks

Posted on

Blog

Useful functions/tips/tricks

Import data from other sheet

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1vNUpW8r1cQd-kPZ21220Lg5yejlGNGP9W6eiVZ_6Hal0cE"; "Master!A2:B3")

Get last non empty value in a column

=INDIRECT("A"&COUNTA(A:A))

Reference: https://stackoverflow.com/questions/8116043/get-the-last-non-empty-cell-in-a-column-in-google-sheetshttps://ttuan.xyz

comments powered by Disqus