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