Dear All,

Thank you for the advice to enlighten me.

Respectfully,
Andri



"Squeaky" wrote:

The number 4 is the result for the frequency of the "1" in your series.

You need to reference the cells as a range, such as a1:a10.
Your formula should look like this:

=frequency(a1:a10,a1:a10) enter it as an array, (ctl-shift-enter), then drag
down the array to copy the formula down at least as many different
frequencies you are looking for plus at least one.

The two portions of the formula reference the same range because you are
looking for the frequency of all the different results.

Squeaky



"Andri" wrote:

Dear All,

Please help for the below formula.

Respectfully,
andry

=FREQUENCY({1,2,1,1,5,6,6,5,5,10,10,1},{1,2,1,1,5, 6,6,5,5,10,10,1}) CSE,
result =4?