(other slight question below)
thanks both !!, would seem to be the right thing.. have to test later, but
wondered if wasn't something alittle simpler than Mod stuff..

as far as selection term goes, I just meant the selection that would occur
from $C$2

what was working on last hour would be a (still not right I think, but
correction on % change formula portion trying to convey, to anyone who
trying to follow, is partial? correction from previous post), is:

=IF(E454=1,IF($C$2=1,EC454/EF454%,
OFFSET(FE454,0,$C$3)/OFFSET(EF454,0,$C$2-1)%),100)-100

Question is this something seen before for part came up with for 1st to IF's,
concept for cascading "IF's", have been using for much longer formula's
have saved much space for many common variables. only pay back I got :)
thanks.


"ShaneDevenshire" wrote:

Hi,

When you say "select" what do you mean?, formulas do not "select" ranges,
they uses ranges to calculate.

Suppose you want to return the value on the first row of every other column
that you indicate by your entry in cell C2, then the formula would be:

=INDEX(E9:X49,1,$C$2*2-1)

but if you want to do something like sum the whole column then the formula
would be

=SUM(INDEX(E9:X49,,$C$2*2-1))


If this helps, then please click the Yes button.
--
Thanks,
Shane Devenshire


"Nastech" wrote:

trying to select every other 1st column, of 2 columns sets.
20 columns, 10 sets. only use one at a time for formula trying to make.
using fixed cell $C$2 to enter 1-10. (first col is a low number, 2nd col is
hi).
selecting 1 column at a time works for the following example.

=INDEX(E49:X9,1,$C$2)

but for example, need 2 to select column G, 3 column I ..
do I need use of / get help with MOD() ?
thanks.