On 2002-04-29 13:28, WYTT wrote:
Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot
On 2002-04-29 14:05, WYTT wrote:
Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?
Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.