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 <aguel...@pyrshep.ca> _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
