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

Foremula Explanation
 

Look in the help index for OFFSET and you will see how to use offset

--
Don Guillett
SalesAid Software

"Prince Ali" wrote in message
...
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 !!!