L
luigi pieri
Having a large table of data, I can calculate the frequency distribution of
the values appearing in each column by mean of the proper function (
FREQUENCE). Often I have to calculate the frequency distribution filtering
the data ( I mean, I have to calculate frequency distribution subject to a
condition ). Unfortunately FILTER hides the rows but the function FREQUENCE
is NOT sensitive to the filtering operation. There is a way to make
sensitive this function to filtering operation ? ( like SUMIF).
Thanks in advance.
Luigi
the values appearing in each column by mean of the proper function (
FREQUENCE). Often I have to calculate the frequency distribution filtering
the data ( I mean, I have to calculate frequency distribution subject to a
condition ). Unfortunately FILTER hides the rows but the function FREQUENCE
is NOT sensitive to the filtering operation. There is a way to make
sensitive this function to filtering operation ? ( like SUMIF).
Thanks in advance.
Luigi