Is there a way to find the last item in a column of numbers and put
that into a different cell at the top of your spreadsheet?

Thanks

If you want to do it by formula:
http://www.dailydoseofexcel.com/arch...he-last-value/

if you want it with VBA:
http://j-walk.com/ss/excel/tips/tip30.htm

Google is your friend :)

hth

Carlo

On Dec 19, 4:12 pm, Peter wrote:
Is there a way to find the last item in a column of numbers and put
that into a different cell at the top of your spreadsheet?

Thanks

=LOOKUP(10^10,J:J)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Peter" wrote in message
...
Is there a way to find the last item in a column of numbers and put
that into a different cell at the top of your spreadsheet?

Thanks

Hey that is pretty slick, thanks.

On Wed, 19 Dec 2007 09:44:05 -0000, "Bob Phillips"
wrote:

=LOOKUP(10^10,J:J)