Selecting the last value of a column

by

Similar answer to caligari’s answer, but we can tidy it up by just specifying the full column range:

=INDEX(G2:G, COUNT(G2:G))

More Related Contents:

  1. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  2. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  3. Refresh data retrieved by a custom function in Google Sheet
  4. Is there a way to evaluate a formula that is stored in a cell?
  5. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  6. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  7. No permission to call msgBox in Google Apps Scripting
  8. Custom functions intermittently hang with “Error – Loading Data”
  9. Apps Script: how to get hyperlink from a cell where there is no formula
  10. Periodically refresh IMPORTXML() spreadsheet function
  11. Using built-in spreadsheet functions in a script
  12. Custom function throws a “You do not have the permission required to setValue” error
  13. Refresh data retrieved by a custom function in Google Sheet
  14. How to evaluate a spreadsheet formula within a custom function?
  15. Google Sheet use Importxml error could not fetch url [duplicate]
  16. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  17. .setFormula() and received error missing ) argument list
  18. Custom Functions and Recalculation
  19. Passing cell references to spreadsheet functions
  20. How to protect the Apps Script code in a Google spreadsheet?
  21. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  22. How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
  23. You do not have permission to call openById
  24. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  25. copy data from one sheet to another in google app script and append a row, one small issue
  26. Google App Scripts cannot be given Authorization or Permission
  27. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  28. Increment Cell value by one by clicking
  29. Google Sheets Formula for Extracting Domain From Website?
  30. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?

Leave a Comment