ExcelBanter - Formula to find the last number of a column (lower cell)

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to find the last number of a column (lower cell) (https://www.excelbanter.com/excel-discussion-misc-queries/262029-formula-find-last-number-column-lower-cell.html)

yiannis5231

Formula to find the last number of a column (lower cell)

I have a column with numbers. I want a formula that it will be finding the
lower cell that has data. For example in column A i have numbers in cells A1,
A2 and A3. In cell A10 i want a fotmula. With this formula will see in cell
A10 the number that i have in cell A3. If i put a number in cell A4 i want
that number to be shown in cell A10.

Jacob Skaria

Formula to find the last number of a column (lower cell)

Try the below in cell A10

=LOOKUP(10^10,A1:A9)

--
Jacob (MVP - Excel)

"yiannis5231" wrote:

I have a column with numbers. I want a formula that it will be finding the
lower cell that has data. For example in column A i have numbers in cells A1,
A2 and A3. In cell A10 i want a fotmula. With this formula will see in cell
A10 the number that i have in cell A3. If i put a number in cell A4 i want
that number to be shown in cell A10.

All times are GMT +1. The time now is 03:13 AM.