=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.