Hi all,
If a formula requires contiguous cells as part of the argument is there some way of creating a contiguous range from non-contiguous cells without moving data?
For example, if I have data in A1, C1 and E1 and would like to use the values to calculate the trend going forward how can I use the TREND formula so that =TREND(array(A1, C1, E1)) becomes the argument for known y's without moving the data into contiguous cell (eg A1:C1)?
Any ideas appreciated - this one's been bugging me for some time!
If a formula requires contiguous cells as part of the argument is there some way of creating a contiguous range from non-contiguous cells without moving data?
For example, if I have data in A1, C1 and E1 and would like to use the values to calculate the trend going forward how can I use the TREND formula so that =TREND(array(A1, C1, E1)) becomes the argument for known y's without moving the data into contiguous cell (eg A1:C1)?
Any ideas appreciated - this one's been bugging me for some time!