| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 !!! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 !!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| explanation of various fields on financial templates | New Users to Excel | |||
| Counting or Total Formulas -- Further Explanation | Excel Worksheet Functions | |||
| Has anyone had formulas change automatically with no explanation? | Excel Worksheet Functions | |||
| Quick Explanation | Excel Worksheet Functions | |||
Linear Mode
