A1 shows address of last cell un a column (e.g. A572 or A577). Every time address will change if adding new row (there can be blank rows in between of rows with data).
I need a link in B1 to click and jump on cell with address shown in A1. I know that can do F5 and type Address in a Go To bar. Just want to eliminate extra steps.
Google-sheets – Jump to cell address mentioned in other cell
formulasgoogle sheets
Related Solutions
I added this formula to your spreadsheet
=ArrayFormula(if(row(B2:B) <= max(if(not(isblank(B2:B)), row(B2:B))),vlookup(row(B2:B),filter({row(B2:B),B2:B},len(B2:B)),2),))
It seems to deliver what you asked, except for the interpolation part. Enter this formula in row 2, no need to drag down. I hope this helps ?
Add the following formula in D2.
Formula
=ARRAYFORMULA(IF(ROW(D2:D) = QUERY({H2:H, ROW(H2:H)},"SELECT Col2 WHERE Col1 <> '' ORDER BY Col2 DESC LIMIT 1"), H1, ""))
It will automatically show the title of the header in column H in the last entry of column H, in column D.
Screenshot
Related Topic
- Google Sheets – How to Live Filter Data
- Google-sheets – In Google Sheets, create a hyperlink in a cell that is clickable directly. No need to hover for popup link
- Google-sheets – Jump to bottom of spreadsheet, blank (non-formula) row
- Google-sheets – Dynamic updating referenced cell from another workbook after adding/deleting rows using IMPORTRANGE – use ARRAY or VLOOKUP
- Google-sheets – The QUERY is giving double results on a single cell
Best Answer
If every cell in Column A (or any other column) has data in it (i.e., no blanks) up to the place you want to go at the bottom of the column, go to any cell in that column and then use the shortcut combination
[Ctrl][down arrow]to get to the bottom quickly.