Hello all !
I have a simple excel table, but i would like to insert n number of rows after a particular row
for example i would like to insert N number of rows if the difference of the B and C column is greater than 0.
And the number of columns to be inserted is the difference between those 2 cells . But (if its possible ) would like to increase the number in the D column by the number of inserted cells
But i dont know what formula to use.
Do someone have any idea?
Thank you in advance and have a great day
Picture 1 how it is
Picture 2 how it would be
I have a simple excel table, but i would like to insert n number of rows after a particular row
for example i would like to insert N number of rows if the difference of the B and C column is greater than 0.
And the number of columns to be inserted is the difference between those 2 cells . But (if its possible ) would like to increase the number in the D column by the number of inserted cells
But i dont know what formula to use.
Do someone have any idea?
Thank you in advance and have a great day
Picture 1 how it is
Picture 2 how it would be
