Hello,
i need to make a loop on the first column (i have data from row3 to row 1987654), and if cell contains create, then add two rows above it and two formulas
<tbody>
</tbody>
¿can you help me?
EDIT:
sorry it wasn´t very well explained.
i need to do the following if in column a it finds create, then insert two rows above and in the first row add the first formula and in then second, the second formula.
thanks
i need to make a loop on the first column (i have data from row3 to row 1987654), and if cell contains create, then add two rows above it and two formulas
- =CONCATENATE("formula1";R[4]C[1])
- =CONCATENATE("formula2";R[2]C[1])
A | B | ||
1 | |||
2 | |||
3 |
<tbody> </tbody> | ||
4 |
<tbody> </tbody> | ||
5 |
<tbody> </tbody> | ||
6 |
<tbody> </tbody> | ||
7 |
<tbody> </tbody> |
<tbody>
</tbody>
¿can you help me?
EDIT:
sorry it wasn´t very well explained.
i need to do the following if in column a it finds create, then insert two rows above and in the first row add the first formula and in then second, the second formula.
thanks
Last edited by a moderator: