help with MOD()
I need to externally designate how many columns offset, the following is an
example using for columns that are next to each other, that works for fixed
cell of $DM$6 (what working on needs cell: $C$2) thanks:
=IF(J9=0,"",SUMPRODUCT(EF9:INDEX(EF9:EX9,1,$DM$6)/EG9:INDEX(EG9:EY9,1,$DM$6)%-100))
"Mike H" wrote:
Hi,
I think you need to post some sample data and a description of what your
trying to do.
Mike
"Nastech" wrote:
hi, not sure if need use of MOD, or INDEX / OFFSET..
I have 10 double columns of data, but only need the 1st col to figure into a
portion of a formula. (specifically, FE - FX), have a fixed cell where
designating number of columns to offset: $C$2
not sure how to apply, but think MOD is needed?
thanks
|