Formula help please

[Bob Newman]

Excel 2010
I assume this requires a lookup or vlookup question, it may be easy
but not for me. I have a column that I log many things into each day
(all on the same worksheet ("2012 Spark Totals" if that information is
needed)). I want to return the value that is the last one in the
column.
ie: a formula in cell B3 that will return the last value in the cell
range of B7:B500. The figures will not go all the way to B500, I just
used that number so the range will cover whatever the length goes to
as we add on to it.

Thanks in advance... Bob

 

[Victor Delta]

Excel 2010
I assume this requires a lookup or vlookup question, it may be easy
but not for me. I have a column that I log many things into each day
(all on the same worksheet ("2012 Spark Totals" if that information is
needed)). I want to return the value that is the last one in the
column.
ie: a formula in cell B3 that will return the last value in the cell
range of B7:B500. The figures will not go all the way to B500, I just
used that number so the range will cover whatever the length goes to
as we add on to it.

Thanks in advance... Bob

Try popping this in B3
=LOOKUP(2,1/(B7:B500<>""),B7:B500)
and it should do the trick.

V