Hi - works for me! See the example:
Book9 |
---|
|
---|
| A | B | C | D |
---|
1 | 1 | | | |
---|
2 | | | | |
---|
3 | 2 | | | |
---|
4 | | | | |
---|
5 | 3 | | | |
---|
6 | | | | |
---|
7 | 4 | | | |
---|
8 | | | | |
---|
9 | 5 | | | |
---|
10 | | | | |
---|
11 | 6 | | | |
---|
12 | | | | |
---|
13 | 7 | | | |
---|
|
---|
i.e.
A1 - enter a 1
A2 - leave blank
A3 - enter the formula & copy down..
=IF(MOD(ROW(),2),A1+1,"")
row() / 2
If the row number / 2 leaves a remainder, then the row number is odd.
mod(row(),2) returns the remainder of the row() / 2 calculation.
It's use in the if() can be 'expressed' roughly as follows:
if the row number divided by 2 gives us anything, add 1 to A1, otherwise nothing.
(This works because excel will treat 0 as false and other numbers as true, which can be exploited within the true / false checking of the if statement).
Paddy