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. Note: The difference between returning …