How to insert a row if the difference between 2 numbers is > than 0 in excel?

p3rand0r

New Member
Joined
Sep 16, 2014
Messages
1
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

 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,876
Members
409,843
Latest member
akostaki
Top