FIND LAST CELL WITH DATA
When I enter this formula it displays the value in cell E220. However, the
last cell with a balance is E225.
" wrote:
It took a bit but here you go
Cell F1: =INDIRECT((ADDRESS(COUNT(E:E),5)))
Sandy
sharon wrote:
No. I have a spreadsheet that tracks a running balance in column E. At the
top of the spreadsheet I want it to display the most current balance by
picking up the last entry in the column.
" wrote:
Here's a macro that will do it and show the value in a message box, is
this what you needed?
Sub LastValue()
Dim Mycell As Object
For Each Mycell In Range("E:E")
If Mycell.Value = "" Then
MsgBox Mycell.Offset(-1, 0)
Exit Sub
End If
Next
End Sub
Sandy
sharon wrote:
I am trying to display the last entry in a column. I am using the following
formula:
=LOOKUP(9.99999999999999E+307,E6:E4000)
My result shows up as zero if cell E4000 has nothing in it.
I am looking for a formula the looks at the entire E column and displays the
value of the last cell with a number in it.
|