View Full Version : Interpolation of data on Excel

03-26-2010, 06:04 AM

Basically my problem is that I haven't got any experience with coding on excel and I have a lot of data that needs sorting at the moment.

What I have is quite a few sets of data, all with two columns in. Basically I will end up plotting these but I need to have the x values at regular intervals whereas at the minute they are not constantly spread.

If anyone could help I basically need a code that somehow stores the (call them x and y for simplicity) two columns of data and then outputs a new spreadsheet with a the x data at set intervals and the new interpolated data for the y set.


03-26-2010, 06:24 AM
Can you share a sample workbook that shows on sheet1 several rows of what the actual data looks like and on sheet2 what you want it to look like.

Make sure sheet1 shows the problem and sheet 2 fixes it.

Also tell us how many rows of data you're talking about. 100, 10,000, 1,000,000

03-26-2010, 12:03 PM
Unless you really want to use VBA, the worksheet Trend () function will do that

Lineral interp sample in attached file, but you can do Log, and Exp. Power is a little tricker

WS 'Raw' is the sparse data, and 'Spread' is evenly spaced

I just used a simple y = f(x) = 1.5x formula