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.
--
get mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML into Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
Personal Information Management > http://Karl-Voit.at/tags/pim/
Emacs-related > http://Karl-Voit.at/tags/emacs/
