Re: Determine min/max values in a table

[Thierry Banel <tbanelwebmin@free.fr>]

Le 02/08/2017 14:07, Karl Voit a écrit :
> Hi!
>
> How can I determine minimum and/or maximum value of a table?
>
> Here is my example:
>
> #+NAME: myvalues
> | Values |
> |--------|
> |      4 |
> |      2 |
> |      3 |
> |      7 |
> |      5 |
> |      6 |
>
> | Min    | Max    | Average | First | Last |
> |--------+--------+---------+-------+------|
> | #ERROR | #ERROR |     4.5 |     4 |    6 |
> #+TBLFM: @2$1='(min (remote(myvalues,@2$1..@>$1)))::@2$2='(max (remote(myvalues,@2$1..@>$1)))::@2$3=vmean(remote(myvalues,@2$1..@>$1))::@2$4=remote(myvalues,@2$1)::@2$5=remote(myvalues,@>$1)
>
> My goal is to get min==2 in the first column and max==7 in the
> second.
>

Alternatively you have the orgtbl-aggregate package available on Melpa.

#+BEGIN: aggregate :table "myvalues" :cols "min(Values) max(Values)
mean(Values)"
| min(Values) | max(Values) | mean(Values) |
|-------------+-------------+--------------|
|           2 |           7 |          4.5 |
#+END: