Getting data from remote cells with OFFSET

If you're trying to write a formula that refers to dynamic data that keeps getting …added to or subtracted from. There could be times when you're trying …to say, I want to get the last entry out of a column or a group of cells. …In this worksheet here called Offset, we got some reporting data information in …column A, and a closing rate, perhaps a stock market rate in column B. …And we want to have, in cell D2, the last reporting date. …The list is going to grow in column A, maybe quite large eventually. …Also, in column B. We always want to see the last reporting date.…

And so, looking at the data right now, in D2, we would like to see 5/15/2013. …And over in E2, we want to see 256. We're going to be using a function called Offset. …If you haven't heard about it, and you might not have encountered the need to …use it. You will find it under Lookup and …Reference functions. And as we slide over the description …here, Offset returns a reference to a range that is a given number of rows and …