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

H

Hal J

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

T. Valko

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

One way:

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

Another way:

=LOOKUP(1E100,AR19:AR31)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
row number of last non-blank cell 14
Reference to next non-blank cell 5
Search for specific text within last non blank cell in a range 2
Counting blank cells between non-blank cells 4
Blank Cells vs. Zero Values 2
How to return the last non-blank cell in a column that is TEXT 7
Next-To-Last, Non-Blank, Rightmost Value in a Row 6

Top