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