How to reference last non-blank cell value from a column cells?
 

I have a column that contains consequtive cells of real numbers followed by
blank cells. The number of cells with real numbers can change but there are
never blank cells mixed in - only blank cells after them. I want to
reference the last real number (last non-blank cell) in a predetermined cell.
For example: Cells AR19:AR31 will contain the real and blank cells. I
want to copy the last non-blank cell from range AR19:AR31 into cell AR 35.

How to reference last non-blank cell value from a column cells?
 

=LOOKUP(2,1/(AR19:AR310),AR19:AR31)

--
Gary''s Student - gsnu200851


"Hal J" wrote:

I have a column that contains consequtive cells of real numbers followed by
blank cells. The number of cells with real numbers can change but there are
never blank cells mixed in - only blank cells after them. I want to
reference the last real number (last non-blank cell) in a predetermined cell.
For example: Cells AR19:AR31 will contain the real and blank cells. I
want to copy the last non-blank cell from range AR19:AR31 into cell AR 35.

How to reference last non-blank cell value from a column cells?
 

I have a column that contains consequtive
cells of real numbers
there are never blank cells mixed in

One way:

=INDEX(AR19:AR31,COUNT(AR19:AR31))

Another way:

=LOOKUP(1E100,AR19:AR31)

--
Biff
Microsoft Excel MVP


"Hal J" <Hal wrote in message
...
I have a column that contains consequtive cells of real numbers followed by
blank cells. The number of cells with real numbers can change but there
are
never blank cells mixed in - only blank cells after them. I want to
reference the last real number (last non-blank cell) in a predetermined
cell.
For example: Cells AR19:AR31 will contain the real and blank cells. I
want to copy the last non-blank cell from range AR19:AR31 into cell AR 35.