| |
|
|
Tutorial
Using XOFFSET to create dynamic ranges
In Excel, the OFFSET function is volatile by design resulting in cells with this function
being recalculated in every recalculation cycle even though its arguments and results have
not changed. Other volatile functions are NOW, TODAY, RAND, INDIRECT, INFO and CELL.
The OFFSET function is particularly useful in creating dynamic ranges used in dashboard
reporting and charting.
In constrast, XOFFSET is a non-volatile function and therefore will not recalculate unless
its arguments have changed. Using XOFFSET is straight forward as shown in the example below.
However XOFFSET will not return any resulting reference which is outside the boundary of the
original reference.
|
|
Please send email to support@zack-soft.com with questions or comments about this web site.
Copyright © 2009 MCC Resources Sdn Bhd
|
