Return the first and last values in a range

Return the first and last values in a range
13 October 2013

I've been asked many times how to find either the cell reference of the first or last value in a range, or even return the values from those cells, and there are many ways to do it.

As usual I'm going to share the methods I think are the best:

  • Find the first value in a range.
  • Find the last value in a range.
  • Find the last number in a range.
  • Using INDEX to return a reference.