Interpolation

[shaero]

Hi Forum,

I want to perform a multi conditional interpolation on my data. For example, I have a table with regions in column A and values in column B:

A B
US 101
US 125
US
US 145
US
JAP 105
JAP
JAP
JAP 513
JAP 623

I would like the formula to interpolate a value in between 125 and 145 for US. Then interpolate a value after 145 for US (not a value between 145 and 105 since those are different regions). And, lastly, to interpolate values in between 105 and 513.

Any ideas?

Thanks in advance,

shaero

 

[Dan Waterloo]

What results do you expect?

 

[jfish1288]

Not sure how this would be possible. In order to do an interpolation, you need each value in the "B" column to have a distinct "A" value

 

[shaero]

What results do you expect?

The data follows an upward pattern, it would be great if the interpolation would be based on a regression model for the particular regions.

 

[Dan Waterloo]

In this part,

A    B
US 101
US 125
US 
US 145
US

what numbers do you expect to see where the blanks are now?

 

[shaero]

In this part,

A    B
US 101
US 125
US 
US 145
US

what numbers do you expect to see where the blanks are now?

Lets say for row 4 an average of 125 and 145 and, for row 6, an estimate based on trends in prior rows for the given region.

 

[Dan Waterloo]

I see.