FIND LAST CELL WITH DATA

[Guest]

Worked like a charm!!! Thanks!!!!!

try this:
=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)

 

[Aladin Akyurek]

What value does

=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)

in contrast to

=LOOKUP(9.99999999999999E+307,E6:E4000)

which appears to return a real 0?

 

[Aladin Akyurek]

What value does

=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)

in contrast to

=LOOKUP(9.99999999999999E+307,E6:E4000)

which appears to return a real 0?

 

[PHOnos]

< 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.

 

[T. Valko]

=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.