ExcelBanter - How do I find the last value of a column

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I find the last value of a column (https://www.excelbanter.com/excel-worksheet-functions/67465-how-do-i-find-last-value-column.html)

sepdan

How do I find the last value of a column

Is there a function that will return the last value of a column or return a
value for that cell?

daddylonglegs

How do I find the last value of a column

To return the last numeric entry in column A

=LOOKUP(9.99999999999999E+307,A:A)

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=505135

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