FIND LAST CELL WITH DATA
=LOOKUP(9.99999999999999E+307,E6:E4000)
My result shows up as zero if cell E4000 has nothing in it.
That formula ignores empty cells (unless *every* cell in the range is
empty).
If you're getting a result of 0 then 0 is the last number in the range but
you may have turned off 0 display or maybe there's a custom/conditional
format set to hide 0s.
--
Biff
Microsoft Excel MVP
"PHOnos" wrote in message
...
< Lookup(L:L,E:E) should return the data in the last cell of column E.
That said, sometimes it works, sometimes it doesn't and I don't know why.
--
-PHOnos
"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.
|