G
Guest
I have a formula as follows, IF(B2="DISTANCE",MAX($A$1:A1)+1,"")
this works great, but I also need to have the blank cells in between the
numbers filled in with numbers eg:
I have need to have:
A1 1 A1 1
A2 blank A2 1
A3 blank A3 1
A4 2 A4 2
A5 blank A5 2
A6 blank A6 2
A7 blank A7 2
A8 blank A8 2
A9 blank A9 2
A10 3 A10 3
A11 blank A11 3
down to 300 rows
Can any one help me please ?
Thank You All
regards bill gras
this works great, but I also need to have the blank cells in between the
numbers filled in with numbers eg:
I have need to have:
A1 1 A1 1
A2 blank A2 1
A3 blank A3 1
A4 2 A4 2
A5 blank A5 2
A6 blank A6 2
A7 blank A7 2
A8 blank A8 2
A9 blank A9 2
A10 3 A10 3
A11 blank A11 3
down to 300 rows
Can any one help me please ?
Thank You All
regards bill gras