ExcelBanter - Last cell in column

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Last cell in column (https://www.excelbanter.com/excel-programming/273000-re-last-cell-column.html)

Bob Phillips[_5_]

Last cell in column

=INDIRECT("A"&MAX(IF(NOT(ISBLANK(A1:A100)),ROW(1:1 00))))

It's an array formula, so enter with Ctrl-Shift-Enter.

--

HTH

Bob Phillips

"Apfreight" wrote in message
...
Searching for a command that will show me the LAST value in a column. Not
the
largest, but the last. Any help0 greatly appreciated.

All times are GMT +1. The time now is 11:24 AM.