As on the example above, I want to display how many times the "Value to count repetition", counted with entire B column in mind, occurred. The number should appear instead of the "x" in the "How many times it has been repeated - A column".

Would you be kind enough to help me out?

Cheers!

CodePudding user response：

try:

=INDEX(COUNTIF(B2:B; B2:B))

CodePudding user response：

Try QUERY() function like-

=QUERY(B2:B,"select B, count(B) where B is not null group by B label count(B) ''")