Cell Reference Question
 

Hey All,
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=500725

Cell Reference Question
 

try:

=LOOKUP(2,1/(A1:A653560),A1:A65356) for column A for example
--
Gary's Student


"tompal" wrote:


Hey All,
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=500725

Cell Reference Question
 

Tom,
your question is a bit confusing. I assume that you mean the last
filled cell in the column and not the cell which was last entered
chronologically (which is much more complex and requires VBA)

=INDEX(H2:H65536, MAX(ROW(2:65536)*--(H2:H65536<"")),0)

It is an array formula, therefore it should be entered with
Shift+Ctrl+Enter.

HTH
Kostis Vezerides