I use this to get the contents of the last cell in a column: =INDEX(FILTER(C:C,NOT(ISBLANK(C:C))),ROWS(FILTER(C:C,NOT(ISBLANK(C:C)))))
But I want the address of that last cell. Does anyone know what I can use? Thanks.
Formula
=ARRAYFORMULA("C"&MAX(IF(ISBLANK(C:C),,ROW(C:C)))
Explanation
We know that the column is C, so the above formula concatenates C to the the row number of the last non-blank (non-empty) cell which is returned by MAX(IF(ISBLANK(C:C),,ROW(C:C))
.
This might be the shortest way to accomplish it:
="C"&max(filter(row(C:C),search(,C:C)))
The irony of this solution is search
returns everything but a blank when you ask it to find blank.
="C"&counta(C:C)+1 maybe? need to add more characters to be able so save the answer
-
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review – serenesat Dec 2 at 6:07
=ADDRESS(row,column,1)
– pjmg Nov 23 at 23:17