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