[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Achim Gratz
Subject: Re: [O] calculate frequencies in a table with calc
Date: Wed, 26 Dec 2012 09:28:55 +0100
User-agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0.11) Gecko/20121115 Thunderbird/10.0.11

Am 25.12.2012 13:59, schrieb Martin Gross:

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 considered.
How could I also include what is inside the brackets, so I get 4?

The Calc manual tells you that vcount flattens nested vectors, vmap doesn't.

Try @6$1=vcount(map(<if(eq(#1,12),1,[])>,vflat(@address@hidden)))
for the second formula.


(on the road :-)

reply via email to

[Prev in Thread] Current Thread [Next in Thread]