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.
INDEXto return a reference.