last row

  • Thread starter Thread starter TJG
  • Start date Start date
T

TJG

Hi,
Is there a function that will tell me the last not null
cell in a worksheet regardless of the column.

Thanks for any help
 
=MAX((A2:Z500<>"")*(ROW(A2:Z500)))

placed in row 1 and enter with Ctrl+Shift+Enter rather than just enter since
it is an array formula. the more cells you include in the formula, the
slower your sheet will calculate, so I would only examine a feasible
reagion.

You will get a circular reference error if you include the cell with the
formula in the range.
 
Back
Top