Yes, of course, but I needn't the highest count, only the highest frequency. I don't know how to create this column. This is an example from Excel: I want to get column (in Obiee): and next I would like to determine the most frequently occurring value: This is my expected result. It is possible to do it? Thank you!

Thank you, but I have one more question. How can I calculate COUNT for the same numbers in Col B?

Ok, I'm sorry that my question was not clear. When I used the above formula I received: What am I doing wrong? In this case, expected result is 21, because occurs most times. Thank you for all the answers.

Thank you for your answer, but that's not what I meant. The expected result for my example above is "4" because number 4 has the highest repeatability. Another example: Maybe someone has right formula or better idea?