I am using Excel 2007 and I would like to interpolate values.
The Xs and Ys will be changing real-time in excel. So the interpolated values need to be updated in real-time as well.
Attached is an example of my data. The values in Column A and B will be changing real-time. Column E values are static and do not change, they will only change if I decide to enter in different values of X to interpolate. The interpolated values in column F will be dynamic and change since columns A and B are changing.