Re: removing duplicates and calculating average values

[Frédéric Parrenin <frederic parrenin univ-grenoble-alpes fr>]

Answering to myself, since I found a solution:
- first you can remove the duplicates of the abscissas by doing an 
advanced filter
- then you can calculate the average of the ordinates by using the 
averageif function.

If there is a simpler solution, I will be glad to hear it.

Best,

Frédéric

Le 16/06/2017 à 16:05, Frédéric Parrenin a écrit :
> Dear all,
>
> I often encounter the following problem in my data analyses.
>
> I have two columns: one is an abscissa in increasing order, the other 
> is an ordinate.
> The abscissas have duplicates.
> So I would like to remove the duplicates in the abscissas and to 
> calculate the average value of the ordinates when there are duplicates.
>
> How can I do that easily?
>
> Thanks in advance for the help,
>
> Frédéric
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list