Selecting the last value of a column

google-apps-script google-sheets google-sheets-formula array-formulas custom-function
cambraca picture cambraca · Nov 13, 2010 · Viewed 100.6k times · Source

I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into another cell.

Something like:

=LAST(G2:G9999)

except that LAST isn't a function.

Answer

dohmoose picture dohmoose · Dec 14, 2012

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))

Related questions

How to insert hyperlink to a cell in Google sheet using formula?

I am trying to insert a hyperlink to a cell in a fashion that can be replicated using '=MATCH()" function. However, I can't seem to figure out a method to link a cell in Google sheets without using the …

Read More
How to union ranges in google spreadsheets

I want to union ranges from any Google spreadsheets. The example Sheet1!A:A {12, 131, 45} Sheet2!A:A {12, 131, 46} The unknown function =formula_for_union_range(Sheet1!A:A; Sheet2!:A:A) should return {12, 131, 45, 12, 131, 46} The question How is it possible?

Read More
Force google sheet formula to recalculate

I have an index/match formula that matches a specific file based on the date value of certain cells. Here's the formula: =IFERROR(INDEX(INDIRECT("'"&TEXT($O$3,"mm-dd-yyyy")&"'!"&"$D3:$D$500"),MATCH($D5,INDIRECT("'" & …

Read More