Is there a binning function for data sets?

Hello,

I have several data sets taken from an instrument recording the same sample. The data are noisy so I would like to average them. Annoyingly, the operating software for the instrument allows you to specify start and end values, but not the amount of points in between (unbelievable, I know). I therefore have data which looks like:

25, 1
25.1, 5
25.6, 7
25.8, 10
25.9, 12

and

25.1, 1
25.4, 4
25.7, 6
25.9, 14

So each replicate has a different sampling rate (the data set is much larger than the example above though). Is there any built-in Excel function to standardize these data to a fixed amount of x values, and perhaps averaging both the X and Y values of all points within the bin?

Thanks,

Dan

I don't think that's quite what I needed... AverageIFs will bin cell "Bn" if the value of "Bn" falls within a criterion. I was looking for something that would bin cell "Bn" of the value of neighboring cell "An" falls within a criterion. It might be a bit much to ask from Excel. In any case, I already wrote a C# program to do it for me.

Thanks!

Dan

Ah yes, you are correct. Sorry, I did misunderstand your post. Fortunately I was firing a cannon at a tank - the C# Excel code was just a nice presentation code to add to a bunch of data parsing and processing - would have taken weeks to do by hand!

Thanks!