# Question Inserting Rows based on cell differences and interpolating in between

• Hello -

I have a complicated issue. I have a file with 5 columns (A, B, C, D, E).
A is fixed string value.
B is a number increasing irregularly.
C, D, E, are given values.

What I need to do is have column B regular (i.e. every 1). So I have to insert rows between B i.e.(B2-B1) will determine how many rows between B1 & B2 and then (B3-B2) will determine how many rows between B2 & B3 and so on.
After inserting the rows, I have to linear interpolate columns C, D & E in the newly created empty rows. In all cases I want to keep the original values and interpolate between them.

The other issue is that column B has decimal/fraction, but I think I can round this to the nearest integer to make it easier for interpolation.

Example Input: http://i65.tinypic.com/v30kz6.jpg
Desired output: http://i66.tinypic.com/2hrod4n.jpg

http://www.mrexcel.com/forum/e…-between.html#post4612064

## Files

• Re: Question Inserting Rows based on cell differences and interpolating in between

• Re: Question Inserting Rows based on cell differences and interpolating in between

Thanks p45cal.

unknown_member - welcome to Ozgrid. Please make sure you post all links - are there any others? You may find that posting in so many places is a disincentive to potential helpers.

Looks like p45cal has solved anyway.

• Re: Question Inserting Rows based on cell differences and interpolating in between

Thanks.

• Re: Question Inserting Rows based on cell differences and interpolating in between

Thanks Alan. I apologized for this and I have followed the instructions. Did I miss something?

• Re: Question Inserting Rows based on cell differences and interpolating in between

No, you've done all required of you now. I think Alan was just pointing out why we ask you to do this - it's not a rule for the sake of it, it's to avoid people wasting time.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!