(no subject)
Dec. 20th, 2009 01:37 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
nonethefewerTo return the last item in an Excel column:
CountA gets the number of non-blank cells in a range.
Index: the array is all values in column G, and the row number is the count of items in column G.
The +3 is there because cells G1-G3 are empty, in my worksheet.
Source.
* This also works in Google Spreadsheets.
* This mostly works in Zoho Sheet. First, semicolons, not commas. Second, it doesn't seem to support
=INDEX(G:G, COUNTA(G:G) + 3)INDEX(Array, Row Number)COUNTA(Value(s))CountA gets the number of non-blank cells in a range.
Index: the array is all values in column G, and the row number is the count of items in column G.
The +3 is there because cells G1-G3 are empty, in my worksheet.
Source.
* This also works in Google Spreadsheets.
* This mostly works in Zoho Sheet. First, semicolons, not commas. Second, it doesn't seem to support
G:G; you need to specify G1:G40 (or whatever).
