Re: distance to the nearest point of a serie

[Andreas Guelzow <aguelzow pyrshep ca>]

On Fri, 2012-02-03 at 17:08 +0100, Frederic Parrenin wrote:
> Dear Gnumericers,
>
> I have two serie X_i and Y_i.
> For each X_i, I would like to compute the distance to the nearest
> point of a serie Y_i.
>
> How to do that in gnumeric?
If A1:A10 contains the X_i and B1:B10 contains the Y_i enter
in C1: =min(abs(A1-$B$1:$B$10))  as an array function
drag this down to C1:C10
C1:C10 contains the distance to the nearest point.

Andreas
-- 
Andreas Guelzow <aguelzow pyrshep ca>