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 ...

Some Excel users are unaware that Sumproduct has a special hidden power which makes the function helpful when picking or amalgamating data from an Excel spreadsheet. Sometimes Sumproduct can be ...

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.