leon313
03-26-2010, 06:04 AM
Hi,
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.
Thanks!
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.
Thanks!