Re: [O] calculate frequencies in a table with calc

2012-12-27 Thread Martin Gross
Dear Achim, > Try @6$1=vcount(map(,vflat(@I..@II))) Excellent. Thank you very much! Sincerely, Martin

Re: [O] calculate frequencies in a table with calc

2012-12-26 Thread Achim Gratz
Am 25.12.2012 13:59, schrieb Martin Gross: #+TBLFM: @5$1=vcount(@I..@II)::@6$1=vcount(map(,@I..@II)) With the first formula (@5$1) everything inside and outside the brackets is counted, but with the second (@6$1), where I am asking for the frequency of 12, only what is outside the brackets is co

[O] calculate frequencies in a table with calc

2012-12-25 Thread Martin Gross
Dear helpers, on the web I found a formula to get frequencies which I modified to my needs, but it does not yet work well. An example: |-| | [1, 2, 3, 4, 5] | | [6, 7, 8] | | [9, 10, 11, 12, 12] | | 12, 12 | |-| | 15