tompal,

Try this:

=OFFSET(H1,COUNTA(H:H)-1,0)

This assumes that you have an entry in every cell in column H between the
top and the bottom.

Regards

Colin
"tompal" wrote in
message ...

Hey All,

This is my first post so I'm not to sure where to put it, but here it
goes:

I have a problem with my worksheet that I am trying to create. I'm
trying to build a sheet that helps me track my "fantasy" stocks. I want
to build it myself b.c that's the type of person that I am. My questions
is how to i program a cell to display the last cell of a specific
column. Basially I want cell B1 to display whatever number is in the
last column of H. Meaning if H7 has the last number in it I want B1 to
display H7, but if H8 is the last cell filled I want B1 to display
that. Is my question clear?

Thanks for the help,

-Tom


--
tompal
------------------------------------------------------------------------
tompal's Profile:
http://www.excelforum.com/member.php...o&userid=30405
View this thread: http://www.excelforum.com/showthread...hreadid=500732