Offset formula

[Aviator]

Chandoo can you please throw some light on offset formula and where all we can use it in excel?

 

[Montrey]

You can use it for pretty much anything and everything.


Dynamic named ranges. Suming dynamic areas using form controls. Charting.


Anytime you want to get data from an array

 

[Aviator]

Thanks Montrey


It would be great If you could just give me few examples.

 

[shailyog]

Aviator


see following links.


http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/


http://chandoo.org/wp/tag/offset/


http://chandoo.org/wp/2011/10/04/offset-function-to-calculate-irr-for-dynamic-range/


http://chandoo.org/forums/topic/need-offset-in-match-index-function