Reply to Message
Filtering Trick
I have been using =MOD(row(cellreference),2) to show 1's and 0's for a long time now....
(I sum every other row in a column by using a MOD() formula too)
@Why? because we have forecasted figures on even rows and actual figures on odd rows down the column and I want to sum them both individually.
(I sum every other row in a column by using a MOD() formula too)
@Why? because we have forecasted figures on even rows and actual figures on odd rows down the column and I want to sum them both individually.
Posted by Gordon Or-8
1st May 2012
