Foremula Explanation

P

Prince Ali

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Quick way to fill formulas? 2
Offset/Match Double Lookup 4
Dynamic Chart Error 3
Automating transposition exercise 2
Use vlookup within offset? 4
alter code to apply to range (links cells w/ row insertions) 1
Mail a different file(s) to each person in a range 0

Top