On Sep 17, 10:06 am, 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?

It actually returns {4;1;0;0;3;2;0;0;0;2;0;0;0}. You need to enter the
CSE formula in 12 cells vertically to get all the answers to show.
With only one cell, it shows the first answer.