Hello everyone,
I have two columns of data: "X" values in A1 thru A200 and their corresponding "Y" values in B1 thru B200.
The numbers in A column starts from -1.4, 0.4 , 1.4 .... up to around 200 (none of those numbers are whole numbers)
In C1 thru C200, I write whole numbers starting with 0 thru 200. These will be the new "X" values.
In the D column I need the corresponding, linear interpolated "Y" values" for each whole number "X" values.
How can I write interpolation in the D Column? (the intervals between each "X" values are not always uniformly spaced)
Thank you
Bookmarks