Tag Archives: offset

Excel: How To Select A Certain Number Of Cells Within A Range

Ok, I tried searching for this and eventually found some results, but thought I’d put up a piece to make it a bit easier for people to find. Basically we want to select a certain number of cells within a … Continue reading

Posted in Excel | Tagged , , | Leave a comment

Excel: How To Select A Cell X Cells Away From Another

To select a cell that is x cells away from another we can use the =offset() formula. Example of how this is very useful: I often have daily or monthly return series, and need to calculate the annual return. So … Continue reading

Posted in Excel | Tagged , , | Leave a comment