Return the first and last values in a range

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.