Determining the last row in a single column

by

How about using a JavaScript trick?

var Avals = ss.getRange("A1:A").getValues();
var Alast = Avals.filter(String).length;

I borrowed this idea from this answer. The Array.filter() method is operating on the Avals array, which contains all the cells in column A. By filtering on a native function’s constructor, we get back only non-null elements.

This works for a single column only; if the range contains multiple columns,then the outcome of filter() will include cells from all columns, and thus be outside the populated dimensions of the range.

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  5. How do I make a Sidebar display values from cells?
  6. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  7. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  8. button click is only working on Windows & not working on Android mobile sheet
  9. Custom functions intermittently hang with “Error – Loading Data”
  10. Retrieving Google Sheets cell border style programmatically
  11. Determining the last row in a single column
  12. Cannot find method getRange(number,number)?
  13. How do I add formulas to Google Sheets using Google Apps Script?
  14. Deleting rows in google sheets using Google Apps Script
  15. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  16. Adding Buttons To Google Sheets and Set value to Cells on clicking
  17. Google apps script to email google spreadsheet excel version [duplicate]
  18. Custom function throws a “You do not have the permission required to setValue” error
  19. Margins parameters for Google spreadsheet export as PDF
  20. Hidden field in a Google Form
  21. Measurement of execution time of built-in functions for Spreadsheet
  22. onEdit() doesn’t catch all changes
  23. Google Spreadheets Scripts: check if cell is empty
  24. Custom Functions with add-ons?
  25. How to prefill Google form checkboxes?
  26. Converting .xls to google spreadsheet in google apps script
  27. Use script in all spreadsheets
  28. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  29. Custom Functions and Recalculation
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment