All the examples above are used to illustrate the different ways you can use the OFFSET function. There may be other, more ...

A good example occurred on a recent training course, concerning the OFFSET() function. This is one of Excel’s Lookup functions and enables a formula to refer to a cell a given number of rows and/or ...

In the past we've looked at how to use Excel's Sumproduct function [1] to pick data out of a table in Excel. That article was in response to a question. Log in Sign up. Subscribe to Newsletter. Search ...

The OFFSET function is probably my favorite function in Excel. When you understand OFFSET you will start dragging the auto-fill handle harder than my uncle Jeff drags on the weekends.. But seriously - ...