If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create array of values returned by named formulas
Hi all,
Is it possible to used named formulas to build an array of values that are not constants. I know you can use the myArray = {0,1,2,3} to build an array of constants but can you simulate this effect with named formulas, e.g. myArray = {myval1, myval2, mval3} where the values are derived by named formulas, eg myval1 = average(some range). I've tried using various syntax and the named range is 'accepted' when entered into the define box but when i come to try and use the name as a chart reference i get an error. Thanks Rob |
Thread Tools | |
Display Modes | |
|
|