Thread: Reference to last cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Reference to last cell
The value of the last number in column A is:

=LOOKUP(9.99999999999999E+307,A:A)

--
Gary''s Student - gsnu200775


"Lawman" wrote:

In an expression, how do I refer to the last cell in a specified column that
is not blank?

Thanks in advance.

H



Reply With QuoteReply With Quote