View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Prince Ali Prince Ali is offline
external usenet poster
 
Posts: 2
Default Foremula Explanation

Hi MPV !!!
I am stuck in a offset formula, can you please elaborate the below mentioned
formulas.

=OFFSET(Sheet1!$B$1,Sheet1!$E$2,0,Sheet1!$E$3,1)

=OFFSET(Sheet1!$B$1,Sheet1!$E$2,1,Sheet1!$E$3,1)

if I need to set five different set of formulas in which each formula shell
cover two set of columns instead of one column as the case of above formula.

Thanks in advance for your valuable advice !!!