Hi there,

I need some help with a spreadsheet and I wonder if one of you could assist?

I have two sets of data, one is a set of measurements and one is a calibration standard (i.e. what the data should be if it was collected perfectly). I want to divide the measurements by the standard to get a response curve. However, the standard has a lot more points in it than the measurement and the points in the standard are not evenly spaced. Here's an example of some of the data:


0.61 400.09
0.61 400.3
0.61 400.52
0.61 400.73
0.62 400.95
0.62 401.16
0.62 401.38
0.62 401.59
0.63 401.81
0.63 402.02
0.63 402.24
0.63 402.45
0.64 402.67
0.64 402.88

Here I'd like to output something like

0.61 400
0.62 401
0.63 403
0.64 404

Is there any way to do this? (It isn't linear the whole way)

Thanks.