• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting most repeated word in multiple cells

Udp

New Member
I have got multiple names in each cell and would like to know which name is repeated maximum number of time and its count?
 
Hi,

If there is no blank, you can use this version too:

A2:A14 supposed your range, enter this in B2 for most common value:
=INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0)))

and this for count:
=COUNTIF(A2:A14,B2)

or combined version:
=INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0)))&" - Count "&COUNTIF(A2:A14,INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0))))

Regards,
 
Back
Top