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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,114,581
Messages
5,548,874
Members
410,881
Latest member
toonces
Top